converting text to number

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

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

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

[Anat]

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

[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.

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

[Kevin Vaughn]

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

[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



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