Yes, but that would only work in one direction or the other, but not both.
--
David Biddulph

"Olle" wrote in message
...
I found the answer my self:

Tools - options - Edit and look for fixed decimal places.

Thanks anyhow // Olle

"Olle" wrote:

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.