View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default converting text to number

Select an empty cell and copy it (ctrl+c). Highlight the data you need
converted and Edit Paste Special, select Add and click OK. (Adding 0
forces Excel to perform the conversion from text to number).

"Anat" wrote:

I have a csv file that I converted to Excel. Some of the data came out as
text for example ' 2568.04. How could I convert these cells to numbers?

Thanks,