Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
The numerical data in my spreadsheet currently rounds to the nearest whole
number. I would like to change all the cells to be rounded to the thousands position. For example, 13,700,800 should be changed to 13,701. Is there a way to do this to "groups of cells" by highlighting the appropriate cells and adjusting them? Using the "Round" command seems to be limited to a single cell; we have tons of data that require reformatting and applying this to each individual cells is an undesirable choice. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
can you use cell references from Microsoft spreadsheet in excel ch | Excel Worksheet Functions | |||
I need to protect all but one cell in an Excel XP spreadsheet. | Excel Discussion (Misc queries) | |||
How do you convert a formula cell to a constant cell | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
How do I convert dollars and cents to text, and prefill the cell . | Excel Worksheet Functions |