Number Format
 

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

Number Format
 

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

Number Format
 

Hi,
Use this
=ROUND(A1/1000,0)
change the cell reference as it suits you
--
_______________________
Click "Yes" if it helps
________
Thanks
Suleman Peerzade


"Nikki" wrote:

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