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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dividing multiple cells by 1000 4
Divide selected cells by 1000 5
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Dividing cells by 1000 1
countif using other cell values for 'range' and 'criteria' 4
How do i create a cumulative worksheet 1
How do I perform calculation within IF statement? 3
Having cells default to 0 2

Back
Top