| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I get all numbers or cells on entire sheet (/1000)?
I want to present a financial report in thousands of dollars. How can I make
all the numbers on my sheet appear as if they had been divided by 1000 without entering my value and a formula in each cell? |
|
#2
|
|||
|
|||
|
To get 12345 to display as 12 use Custom Format #,##0,
To see 12.35 use #,##0.00, Select all the cell to change; use menu command Format|Cell, slide down to Custom and type the format in the text box best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "jem" wrote in message ... I want to present a financial report in thousands of dollars. How can I make all the numbers on my sheet appear as if they had been divided by 1000 without entering my value and a formula in each cell? |
|
#3
|
|||
|
|||
|
Hi Jem
Enter 1000 in a empty cell Copy this cell Select all the cells with numbers right click on the selection Paste Special .. Divide OK -- Regards Ron de Bruin http://www.rondebruin.nl "jem" wrote in message ... I want to present a financial report in thousands of dollars. How can I make all the numbers on my sheet appear as if they had been divided by 1000 without entering my value and a formula in each cell? |
|
#4
|
|||
|
|||
|
Oops
You say <appear as if they had been divided by 1000 See reply from Bernard -- Regards Ron de Bruin http://www.rondebruin.nl "Ron de Bruin" wrote in message ... Hi Jem Enter 1000 in a empty cell Copy this cell Select all the cells with numbers right click on the selection Paste Special .. Divide OK -- Regards Ron de Bruin http://www.rondebruin.nl "jem" wrote in message ... I want to present a financial report in thousands of dollars. How can I make all the numbers on my sheet appear as if they had been divided by 1000 without entering my value and a formula in each cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I add cells from sheet to sheet? | Excel Worksheet Functions | |||
| Hightlighting Numbers & then all Cells to the right of these Numbers. | Excel Worksheet Functions | |||
| insert text in a no. of cells of each sheet? | Excel Discussion (Misc queries) | |||
| I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
| Linking to an Entire Sheet | Links and Linking in Excel | |||
Linear Mode
