Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to round all numbers in a worksheet to, say 1,000s?
How to round all numbers in a worksheet to, say 1,000s, instead of typing the
=round(n,-3) over and over? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to round all numbers in a worksheet to, say 1,000s?
If you just want them to look rounded then format the cells using a custom
number format like: #,###, -- Regards, Tom Ogilvy "JCMKM" wrote in message ... How to round all numbers in a worksheet to, say 1,000s, instead of typing the =round(n,-3) over and over? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to round all numbers in a worksheet to, say 1,000s?
If you do that, you can round them by choosing Tools/Options/Calculation
and checking the Precision as displayed checkbox. After the conversion, you can uncheck that checkbox and reformat if desired. In article , "Tom Ogilvy" wrote: If you just want them to look rounded then format the cells using a custom number format like: #,###, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
round numbers in the millions to numbers in the thousands | Excel Worksheet Functions | |||
SUMIF, Text, and Leading, 000s | Excel Worksheet Functions | |||
Rounding 1,000s | Excel Discussion (Misc queries) | |||
EXCEL: display number in '000s ie £15000 show as £15 | Excel Discussion (Misc queries) | |||
Can you round numbers to display a specific set of numbers, for e. | Excel Discussion (Misc queries) |