Text Function 2nd argument
Actually, the back slash in front of the $ sign isn't needed...
=TEXT(A1,"$0.0,,\M")
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
A little bit more compact (and no worries about double quotes)...
=TEXT(A1,"\$0.0,,\M")
--
Rick (MVP - Excel)
"Gary''s Student" wrote in
message ...
=TEXT(A1,"""$""0.0,,""M""")
BE CAREFUL of the number and location of the double quotes!!
--
Gary''s Student - gsnu200812
"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:)
|