Engineering Notation

[willhen50]

I am trying to apply engineering notation to specific applications, and I have somewhat gotten the numbers to be in the scientific notation, but how do I change 10.0E+3 to equal 10K, or 10E-3 to equal 10m. Much better would be to get the Meg or nano values, all I get is E+ or E- 3.
You would think a program like Excel would implement some features that is available in a $10 calculator.

 

[westconn1]

i am sure there must be a better way, but
=VALUE(TEXT(A8,"#.###########"))