convert text to numbers

[L.LEE]

Hi

I have a cell that contains the text "4.05T". How do I have another cell pointing to this cell that just returns "4005000000000" as a number?

thanks

[mcmahobt]

There isn't a typo in your example is there? Are you sure there should read two zeros between the 4 and 5 in "4005000000000" and not "405000000000000"?

Assuming you mean 4.05 Trillion, and not 4.005 Trillion, you could use this formula:

Please Login or Register  to view this content.

And reformat as a number if you do not like scientific notation. This is also assuming your "4.05T" is in cell A1.

Hope this helps!

[L.LEE]

You are right. It should be 405000000000000.

[mcmahobt]

See edit above for possible solution.

[XOR LX]

Hi.

Perhaps also:

=0+SUBSTITUTE(A1,"T","E12")

Regards

[L.LEE]

Thanks for providing an alternative method.