Excel Worksheet?

Question

I have a worksheet where the number are all useful however, the data I have I need to divide by 1000. There are quite a few numbers to do so. Is there an easy way to do it?

Thanks

Answer 1

First, make a copy. Keep the original.
Insert a new sheet. In the new sheet, type 1000 in cell a1.
Select cell a1, right click copy. The 1000 is now in memory.

In the copied sheet (where all the useful numbers are)
Select all the useful numbers.
Go to Edit. pastespecial, select option value, select option divide

All the useful numbers are now divided by 1000.

The above sounds too complicated. So there is always a better way.

Select all the useful numbers, format cell, select custom,
select your favourite format but add comma at the end
'0.00' become '0.00,' (see the comma at the end).

Basically you want your numbers to appear in thousands and the last trick is the best I have found so far.

Answer 2

Yes, all you need to do is this: Put an equation on the first space where the ans is going to be, for example @sum(A10/1000) when you are sure that works go and copy or add again the equation to the others.

You should be able to copy all if you data is neatly organized neatly.

Hope that I helped

kisses

Answer 3

If you have the number 2300 in cell A1, enter the formula =A1/1000 in cell A2.

If your numbers are in cells A1, B1, C1, etc., copy the formula from cell A2 to cells B2, C2, etc.

Answer 4

position the cursor the position you would like the entire and then you'll click on the formula signal interior the icon device bar. click in this and it is going to automaticly do the formula for you. or you could type =sum(A1:A16) and this can upload up all the suggestion for you. or you could type =sum( then click on the first cellular you want interior the formula and drag the mouse down highlighting all the cells you require. Then type ) and hit enter. wish this has helped.

Answer 5

Try highliting all the numbers you need to divide, and type in /100.