Format numbers using prefixes

[jeff]

Hi,

Here's something for your 2nd question:

=A1/1024^(INT(LOG(A1,1024))) & " " &CHOOSE(INT(LOG
(A1,1024))+1,"bytes","KB","MB","GB","TB","PB","EB")


You can probably modify it for your first question.

jeff

-----Original Message-----
For example, I want to display the number "3400000"

as "3.4M." How do I do this in Excel, or do I need an
add-in? I want to use k, M, G, and T for thousand,
million, billion, and trillion. Thanks.

PS also helpful if Excel could format numbers using

binary prefixes--i.e. display 2097152bytes as 2.0MB--but
this is second priority to the first question.