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,
|