Number Format

[Nikki]

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

 

[Bernard Liengme]

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

 

[Suleman Peerzade]

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