There are common issues that occur when using Excel to format your data list from the county. These issues revolve around the Assessor’s Parcel Number (APN) and Zip code fields.
See Excel is a financial software used mainly by accountants so a lot of the built in functions are designed with that in mind. So for example, if you import a list that has a zip code of 04574 in it, Excel will convert that to 4574 because 04574 is not a valid financial number. Take a look at this article that explains how you can overcome that:
The other issue that Excel has is when you have APN numbers that are long numeric values like 321049105002 …when Excel reads that number it will convert it to a scientifically notated value like 3.21049E+11
and if you import that into the Investment Dominator your APN’s will not be correct.
How To Format The APN Column Correctly In Excel
To format the APN column correctly in Excel right-click over the column and choose the ‘Format Cells’ option. Then select the ‘Number’ category on the left side and change the ‘Decimal Places’ value to 0. Click ‘OK’ at the bottom of the screen to update the format of that column.
By doing this you preserve the original format of the APN’s and remove the scientific notation that Excel uses by default.
You will want to format also any Zip Code fields you have in your list. To do this follow the instructions in this article:
How To Search For, Or Filter/ Group Records
You can locate property records by using the 'Search By' option located at the top ...read more
How To Merge Property Records
In rare cases where the owner request and offer from your buying website and does ...read more
How To Customize The P.S. Line In The Neutral Letter Template
The built-in Neutral Letter template has a P.S. line that states how you can be ...read more