The "M" in 300M is neither binary nor a prefix.

I know of no native format that will recognize and interpret such inputs as
numbers, but you can easily write a formula to covert them, such as
=IF(RIGHT(cel,1)="M",LEFT(cel,LEN(cel)-1)*10^6)
You could nest IF statements to recognize up to five possible postfixes.
For more you could use VLOOKUP to get the values from a table.

"K" is an ambigous postfix, that may either mean 1000 or 1024=2^10.

Jerry

"Dogbert" wrote:


Dear forum users,

There is a problem I wonder if you could help me with. Perhaps it is a
simple matter but I have been unable to find the answer.

Large numbers are commonly abbreviated with binary prefixes, especially
in finance. By binary prefix, I am referring to the use of a single
letter to represent the order of magnitude of a number. For instance
"K" represents a thousand, and "M" denotes a million. e.g. The
population of the US is around 300M (or 0.3B).

So when I have a column of numbers such as "... 8000; 9000; 10K;
11K...", I want Excel to convert or recognise the value of "K". At the
moment, Excel is just treating this as text. Does anyone know how to do
this?

Thank you in advance for your help.


--
Dogbert
------------------------------------------------------------------------
Dogbert's Profile: http://www.excelforum.com/member.php...o&userid=35338
View this thread: http://www.excelforum.com/showthread...hreadid=551072