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?