View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default excel 2007 numbers truncated

Click the round "Office" Icon at the left upper corner Excel Options
'Advanced' and in the 'Edit options' cancel the selection from 'Add Fixed
Decimal Automatically...'
Micky


"AQUICKPRINT" wrote:

I open a new sheet and tried to place a four digit number in the box. the
moment
I go to another box the number reverts to the first two digits. Can you
tell me how
to stop that from happening. I need to four digit numbering and haven't
been able to set up the proper numbers????