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