How can I set Numbers to automatically divide rows by 100? For example, I input 7865 and when I press return to go to the next cell, the number becomes 78.65.
Thanks.
(I'm on El Capitan, using Numbers version 3.5.3)
Numbers does not have a feature that will take an entry from a cell, modify the value, then put the result in the same cell. You can, solve this two ways:
1) add a second column that takes input from the column where you enter the values, and performs the operation
2) create an Applescript which you run AFTER you enter the data which can modify the contents of each cell in the column using a particular scale factor
If you are entering the data in column A, then in column B enter the formula:
=A/100
select the cell, copy, now select the column, paste
Numbers does not have a feature that will take an entry from a cell, modify the value, then put the result in the same cell. You can, solve this two ways:
1) add a second column that takes input from the column where you enter the values, and performs the operation
2) create an Applescript which you run AFTER you enter the data which can modify the contents of each cell in the column using a particular scale factor
If you are entering the data in column A, then in column B enter the formula:
=A/100
select the cell, copy, now select the column, paste
Thanks!
Automatically divide cells by 100?
