Custom format:

#.000,, "Million"

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"xman123" wrote in
message ...

hello

how to convert 1000000 convert to 1.000 or 1.000 Million


--
xman123
------------------------------------------------------------------------
xman123's Profile:
http://www.excelforum.com/member.php...o&userid=35532
View this thread: http://www.excelforum.com/showthread...hreadid=557582