Forum Discussion
cell format
When I write a number or a sum in a cell, I want this number appears divided by 656
That is dangerous. Let's say you enter 860672 in a cell.
It automatically changes to 860672/656 = 1312,
Now you accidentally enter edit mode and press Tab or Enter instead of Esc.
The number now changes to 1312/656 = 2.
It's better to use a formula in another cell, for example the cell to the right, that divides the number by 656.
For example, you enter a value in A2. In B2: =A2/656
Thanks for your answer. I used a VBA macro, it open a window with the answer when I write a numéro in the cell.
