converting text to number
 

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,

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,

converting text to number
 

bpeltzer - it didn't work :(

"bpeltzer" wrote:

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,

converting text to number
 

Try replacing the single quote with nothing.
--
Kevin Vaughn


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

converting text to number
 

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.

"Anat" wrote:

bpeltzer - it didn't work :(

"bpeltzer" wrote:

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,

converting text to number
 

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



"Kevin Vaughn" wrote:

Try replacing the single quote with nothing.
--
Kevin Vaughn


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