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?

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?

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?

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?