View original (French)

Divide an entire column by 1000

Solved
Fifih26 Posted messages 14 Status Membre -  
 ionys -
Hello,

I would like to know how to divide an entire column by 1000. The rows are already filled with different numbers and I need to divide them all by 1000.
What I want to do is for example divide column A by 1000. How can I do that? I don't want to redo every line in column A one by one.

3 réponses

Réponse 1 / 3
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Hello,

even simpler:
- enter 1000 in a cell and copy it
- select your column and then special paste divide
eric

--
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it will work. (the Shadoks)
In addition to the thank you (yes, it does happen!!!), please remember to mark it as resolved. Thank you.
2
ionys
 
top !!
0
Réponse 2 / 3
PapyLuc51 Posted messages 4566 Registration date   Status Membre Last intervention   1 509
 
Hello

No specification whether it's line by line or if it's the sum of the numbers in the column that need to be divided by 1000

The data is in column A starting from A1

For the division per line 
=A1/1000
to be dragged down.

For the sum of the column 
=sum(A:A)/1000


Best regards
1
Réponse 3 / 3
Fifih26 Posted messages 14 Status Membre
 
Thank you very much for your answers.
0