value convert

[xman123]

hello

how to convert 1000000 convert to 1.000 or 1.000 Million

[RagDyeR]

Custom format:

#.000,, "Million"

--

HTH,

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


"xman123" <[email protected]> wrote in
message news:[email protected]...

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