Thread: entering a whole number e.g. 4, results in a decimal entry, 0.04
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default entering a whole number e.g. 4, results in a decimal entry, 0.04
In Options, Uncheck Automatically insert a decimal point.

Bluebottle wrote:

my excel 2003 suddenly developed the above fault, which try as I may, I
cannot cure. If I enter the number with a decimal point after it, it enters
as the correct whole number. The selfsame programme on my Vista laptop has
not developed the fault (yet, anyway!)
Anyone come across this before? Thanks for your attention,
J.Fulcher

Reply With QuoteReply With Quote