How do I round a number to the nearest thousand in Excel???
Hello, Round!
You wrote on Thu, 14 Sep 2006 08:19:03 -0700:
Rtr Hi need help fast....
Rtr I need to round my number to the nearest thouseand.
Rtr Example 123,456.7890
Rtr I want it to read 123
Rtr I formatted to the deimal is rounded but can't round the
Rtr comma.... I tried the custom cell formatting options...No
Rtr Luck HELP
HELP is what to use!
Anyway, =round(a1/1000,0)
James Silverton
Potomac, Maryland
E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not
|