View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default 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