| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Round to Nearest Thousand
I posted this earlier but didn't get the answer I needed so will try again.
I have a user who wants a custom FORMAT to round to the nearest thousand. (Eg if she has 104580, she wants it to round to 105000.) I tried #,##0 but it takes off the last three 0's which need to display. Does anyone know the syntax for this? She does not want to use the ROUND function; she needs the actual number to remain for calculating, she just wants to change the display. Thanks for your help! -- Thanks, GillianHG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Round a number to the Nearest .25 | Excel Worksheet Functions | |||
| How to convert number in word format like (1000 i.e. One Thousand | Excel Discussion (Misc queries) | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
| Rounding numbers to the nearest thousand | Excel Discussion (Misc queries) | |||
Threaded Mode
