MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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:

#'##0 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??


Posted by Dank on November 14, 2001 3:25 AM


How about selecting the range in question and choosing Edit, Replace and replace the apostrophe with nothing.


Posted by Hodge on November 14, 2001 5:12 AM

You can do this with a custom number format.

- Select you cells
- Format Cells
- Number Tab
- Custom
- Enter #'##0 into the "Type" field

That should do it.