Dec 9, 2013
In my last tutorial I showed you how to convert text-based numbers to numeric values. Not only were the numbers stored as text, they also had the comma and decimal point reversed (at least they did for my UK customer). If you missed the tutorial or want a reminder,...
Nov 25, 2013
A customer sent me a spreadsheet containing data that had been exported from another system asked me to convert the “values” in column A (which were text) to numeric values. **Download the sample spreadsheet here** The first thing that I noticed was that there was at...
