No good. This assumes the amount is actually a million.

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
Format Custom as

#,##0,,",000,000"

(no provisions for negative amounts yet)

But are you sure you need this? I don't like the idea of displaying
something that is not the actual amount in the cell. What is your
requirement, if I may ask?

"tinybunny_8"
wrote in message
...

Hi there,

I saw an article in this web about formatting a number to million using
the following format:
#,##0,, ;[Red](#,##0,,);- ;

So, if I have 1,777,777 I will get 2. However, what if I want to
display 2,000,000 instead of only 2? How can I do that? Thank you.


--
tinybunny_8
------------------------------------------------------------------------
tinybunny_8's Profile:
http://www.excelforum.com/member.php...o&userid=31070
View this thread:
http://www.excelforum.com/showthread...hreadid=507477