How do I get all numbers or cells on entire sheet (/1000)?

J

jem

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?
 
B

Bernard Liengme

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
 
R

Ron de Bruin

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
 
R

Ron de Bruin

Oops

You say <appear as if they had been divided by 1000>
See reply from Bernard
 
Top