1000 to 1 and 1 to 1000
"Olle" wrote in message
...
When I type 1000 in one cell and then push enter, I would like that only 1
is
shown.
Vice versa, typing 1 - I would like the cell to show 1000.
You could use Tools/ AutoCorrect Options, but it sounds a dangerous way of
asking your sheet to behave.
--
David Biddulph
|