View original (French)

Divide an entire column by 1000

Solved
Fifih26 Posted messages 14 Status Member -  
 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 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor 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
    1. ionys
       
      top !!
      0
  2. PapyLuc51 Posted messages 4579 Registration date   Status Member Last intervention   1 515
     
    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
  3. Fifih26 Posted messages 14 Status Member
     
    Thank you very much for your answers.
    0