| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cell to the nearest 100
Is there a format for rounding a cell to the nearest 100 so that 501.35
rounds to 500. I was using #,##0 to just round to the dollar, but I want to got to the nearest 100. Any thoughts? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I round a number to the nearest .49 in a cell that has a fo | Excel Worksheet Functions | |||
| How to search for nearest nonblank cell in previous rows? | Excel Discussion (Misc queries) | |||
| Format number cells to the nearest 1,000 | Excel Discussion (Misc queries) | |||
| Format Round to Nearest Thousand | Excel Discussion (Misc queries) | |||
| How do I format cells to round to the nearest thousands without .. | Excel Discussion (Misc queries) | |||
Threaded Mode
