converting text to number

A

Anat

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

bpeltzer

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).
 
A

Anat

bpeltzer - it didn't work :(

bpeltzer said:
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).
Click to expand...
 
B

bpeltzer

Hmmm, haven't seen that not work.
Suppose your data starts in cell B2. In a blank cell of that row, enter the
formula =value(b2). Autofill the formula down through the entire table.
Select that column, copy (ctrl + c) and Edit > Paste Special, select Values
and Paste. That column should now have all your numbers.
 
A

Anat

Sorry for the long delay -busy with work. It seems like it doesn't work with
csv files. But the text to colum works.

Thank you both.

Anat
 
Top