Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting rid of thousands of rows Excel 2002 | Excel Discussion (Misc queries) | |||
On Excel I need to round up in tens of thousands | Excel Discussion (Misc queries) | |||
Rounding a formula result to read thousands from millions. | Excel Worksheet Functions | |||
Rounding to thousands | Excel Discussion (Misc queries) | |||
separator of thousands | Excel Discussion (Misc queries) |