Have you thought of =ROUND(your-formula,-6) ?

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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