excel 2007 numbers truncated

  • Thread starter Thread starter AQUICKPRINT
  • Start date Start date
A

AQUICKPRINT

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????
 
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
 
Back
Top