Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I've noticed in some spreadsheets that numbers are displayed as
rounded...i.e. so that one isn't looking at 1,403,333 + 2,333,999 etc. but rather 1403 + 2334, etc. with a note at the top that says "000's". In one step, how can I edit all the numbers in a table so that they show to the nearest 10,000 (i.e. 1403 +2334), without dividing them one by one by 1,000? Or, to go at it from another angle, how do I divide each # by 1,000? The ROUND feature requires that I create a new table. Not exactly what I'm looking for. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Divide 2 pivot table numbers | Excel Worksheet Functions | |||
how to divide numbers | Excel Worksheet Functions | |||
How to divide numbers in Excel? | Excel Worksheet Functions | |||
Numbers divide by 10 in any cell... | Excel Discussion (Misc queries) | |||
My excel2000 divide numbers per 10 why? | Excel Discussion (Misc queries) |