Dividing by 1000 without a formula!

  • Thread starter Thread starter urbanhymn
  • Start date Start date
U

urbanhymn

When I try to enter a whole number into a spreadsheet for example "99
enter" it appears as .999 in the cell. There is no formula in the cel
- repeat no formula in the cell! However when I enter 9.99 it appear
in the cell as 9.99 no problem! This excel 2000 was working fine unti
about a week ago.
Has anybody got any ideas? I apologise if this is a dumb question tha
gets asked a lot.
:confused
 
It gets asked a lot but it is not dumb, tools>options>edit and uncheck fixed
decimal places.

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Thank you Peo - that sorted it straightaway. It was a dumb question
can see that now! Thanks for taking the time to reply.
Regards,
Richard Clegg
Wolverhampton, Englan
 
Back
Top