This *can* be accomplished with custom formatting:

[<=999999]#.#," Thousand";[999999]#.#,," Million";General

--

Regards,

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

"raypayette" wrote
in message ...

This isn't a formatting problem. The data should be divided by 1000,
THEN you deal with the presentation (such as rounding)!


--
raypayette


------------------------------------------------------------------------
raypayette's Profile:
http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=563634