Forum Discussion
Number format
As a Realtor I have, over the years, downloaded bulk MLS data for offline processing in Excel for the benefit of my buyer and seller clients. There was never a problem until the MLS service (Garden S...
Your sample file does not appear to contain data which has been downloaded from anywhere? To convert the data to numbers, simply do a search and replace, replacing the $ character with nothing. Also, each number appears to have a character behind it which needs to be removed. It is character 160 (non-breaking space character) so another S&R operation is needed for that.
Still no luck. Tried substitute...SUBSTITUTE(D2,CHAR(160),"")...and clean and the text was still unworkable.
- You were close. Substitute produces text so the trick is to multiply the result by 1, see attached.
- I clicked on the formula bar and noticed there was some character behind the numbers. Then I used =code(right(a1, 1)) to get the ascii code