Formatting a decimal representation of millions

[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

 

[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)

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[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>