View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Vonne Vonne is offline
external usenet poster
 
Posts: 1
Default The numbers I enter are changed when I leave the cell

Yes, thank you from me too. Every time I typed in a whole number I ended up
with 2 decimal places, and not being very computer literate was having a
tough time of it. I did well to find this site.

Cheers, Vonne

"Gord Dibben" wrote:

ToolsOptionsEdit. Uncheck "fixed decimal places"


Gord Dibben MS Excel MVP

On Sat, 3 Mar 2007 09:04:08 -0800, kg_ce
wrote:

Since yesterday if I enter a whole number in a cell, for example 123, when I
leave the cell it appears displayed as 0,0123. Why does this happen and how
can I change it???