Enter Whole Numbers

  • Thread starter Thread starter chesjak
  • Start date Start date
C

chesjak

Excel XP Windows XP
In the past when I entered a number,say 15, and pressed
return, it showed a 15 Now it shows a 1.50 I have gone
into "Edit Cell" but the only relevant thing I can alter
there is the number of decimal places. I have also looked
at "options" but to no avail. I would ad this is in
worksheets that I had initially formated and it was
working.

Anyone got any ideas as to what I need to do to rectify
the problem
 
In Excel go to Tools Options Edit Uncheck the box by Fixed Decimal place


: Excel XP Windows XP
: In the past when I entered a number,say 15, and pressed
: return, it showed a 15 Now it shows a 1.50 I have gone
: into "Edit Cell" but the only relevant thing I can alter
: there is the number of decimal places. I have also looked
: at "options" but to no avail. I would ad this is in
: worksheets that I had initially formated and it was
: working.
:
: Anyone got any ideas as to what I need to do to rectify
: the problem
 
Back
Top