PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Setup Enter Whole Numbers

Reply

Enter Whole Numbers

 
Thread Tools Rate Thread
Old 30-04-2004, 03:51 PM   #1
chesjak
Guest
 
Posts: n/a
Default Enter Whole Numbers


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
  Reply With Quote
Old 30-04-2004, 04:32 PM   #2
Lady Layla
Guest
 
Posts: n/a
Default Re: Enter Whole Numbers

In Excel go to Tools Options Edit Uncheck the box by Fixed Decimal place


"chesjak" <anonymous@discussions.microsoft.com> wrote in message
news:689301c42ec2$9d495b20$a401280a@phx.gbl...
: 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


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off