Use custom format 0,; to show thousands
Or 0,,; to show millions

Remember that this will NOT alter the stored value, only the display
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Nikki" wrote in message
...
Does anyone know how I could automatically format a number to change from
1,776,176 to 1,776? I can insert a round number but it doesn't drop the
000's.

Thanks