missed the dollar bit

[=1000000]"$"0,,"M";[=1000]"$"0,"K";0

Just a point, you may have a reason for wanting to use text but if you do
it's no longer a number. Using a format doesn't change the underlying value,
only what you see.

Mike

"Mike H" wrote:

Hi,

Here's a number format that does what you want
[=1000000]0,,"M" ;General

but its better I think) if you adapt this to include thousands with this

[=1000000]0,,"M";[=1000]0,"K";0

Mike
"Gene" wrote:

I would like to format 1000000 (1 million) using the Text Function into $1M.
It works for K:
a1=1000
=TEXT(D15,"$#,###,k") Works fine
but
when a1=1000000
and I replace the K with an M, I get a #value error
I would like my end result to look like: $1M

It was successful just using the Formatcellscustom.
THANKS!
Gene:)