Enter Whole Numbers

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
 
L

Lady Layla

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Decimal/Percentage to Whole Number 4
entering whole numbers: formula bar 2
Checking for whole numbers in a worksheet 1
Automatically chnage number format of a range of cells 2
Problem entering numbers 3
Why wont this control show whole numbers? 2
Outlook 2010 Contacts 0

Top