Some symbols are predefined: D, DD, DDD, M, MM, MMM, H, HH, M, MM, S, SS....

Maybe just telling excel that you want the character M is best:

=TEXT(A8/1000000,"#.00 \M")



Bernard Liengme wrote:

Why is this OK: =TEXT(A8/1000,"#.00 K")
But this returns #VALUE!: =TEXT(A8/1000000,"#.00 M")
(I know I can use =TEXT(A8/1000000,"#.00")&" M" )
It seems some letters are allowed as part of the format in TEXT while others
are not.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

--

Dave Peterson