string -> number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kaokao1 - 08 Jun 2006 04:16 GMT

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

Reply to this Message

Pete_UK - 08 Jun 2006 09:01 GMT

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

> Please:
> How can I change a string into a number?
[quoted text clipped - 11 lines]
> kaokao1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35005
> View this thread: http://www.excelforum.com/showthread.php?threadid=549782

Reply to this Message

kaokao1 - 09 Jun 2006 03:47 GMT

Thanks, Pet

Reply to this Message

Pete_UK - 09 Jun 2006 09:35 GMT

You're welcome.

Pete

> Thanks, Pete
>
[quoted text clipped - 3 lines]
> kaokao1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35005
> View this thread: http://www.excelforum.com/showthread.php?threadid=549782

Reply to this Message