Formatting a decimal representation of millions

S

stunnie

Hi,

How can I format a number in a cell such as 0.55 (the cell heading is $
millions in another cell to read $550K? Is this possible?

Thanks,

s
 
D

Dave Peterson

This will return text:
=TEXT(A1*1000000,"$0,")&"K"

This will return a value (in millions):
=A1*1000000
but give it a custom format of:
$0,K
(Format|cells|number tab|custom category)
 
B

Bob Phillips

=TEXT(A1*1000,"$0\K")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
D

Dave Peterson

Hmmm.

I guess that multiplying by a million and dividing by 1000 isn't time well
spent????

But even shorter:
=TEXT(A1*1000,"$0K")
<gd&r>
 
Top