string -> number

K

kaokao1

Please:
How can I change a string into a number?
From a data base I have

-2,438E-04 (cientific notation)

I want Excel takes it like a number.
(Excel takes it as a string!!)
Than you very muc
 
P

Pete_UK

Enter this formula in a blank cell somewhere:

=VALUE(A1)

assuming the data is in A1. If you have a lot of these in column A, you
can copy the formula down. You can then use <copy> | Edit | Paste
Special | Values to convert the formula to a value and over-write the
original string in A1.

Hope this helps.

Pete
 
Top