PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Enter Whole Numbers
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Setup
Enter Whole Numbers
![]() |
Enter Whole Numbers |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
|
|
#2 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

