View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
evoxfan evoxfan is offline
external usenet poster
 
Posts: 65
Default Number Text Format

I have a column of numbers formatted as text such as:
099.600
'101.550
102.000
'104.430
105.500

Some numbers have an apostrophe in front and some do not.

I would like to make all the numbers in this column consistent without the
apostrophe. I would also like to keep them as text since converting them to
numbers would likely get rid of the first character for numbers less than 100.

What is the best way to accomplish this?

Thanks in advance for your help.