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.
JKPieterse Thank you. I'll try it. How do you conduct a search and replace using a character number?