View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] bridgetv@gmail.com is offline
external usenet poster
 
Posts: 6
Default Rounding to thousands in excel

Does anyone know of a way to round to thousands in excel with a custom
format. I am trying to round as follows:

If the number is 49,677,298.86 I want 49,600 to display
If the number is 3,037,136.67 I want 3,000 to display
If hte number is 2,369,098.33 I want 2,400 to display

Thanks for your help.