Posted by George on November 14, 2001 2:26 AM
I have a large spreadsheet with a huge table of numbers in it.
The trouble is, each number is written in the following format:
..so 2345 looks like 2'345 in the cell - it is, in fact text.
How can I reformate these numbers from this text format into a number format without having to remove the " ' " from each number so that 2'345 reads 2345, so it can be used in calculations??