Why do my numbers keep going down decimal places?

E

Excell2002ishard

Whenever I post any number in Excell 2002 it goes down exactly two decimal
places and rounds.
For example, I post 8 and it shows up as 0. Clicking the cell reveals that
it has changed into 0.08. Please help!
 
M

Max

It's probably just a fixed decimal setting
Click Tools > Options > Edit tab
Uncheck "Fixed decimal" > OK
should get things back to normal
 
L

looneylmt

You need to format the column. Click the column, right click, format cells,
then choose numbers, set the decimal place where you need it to be.
 

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

eliminating decimal places 3
More than two decimal places 1
Addition errors with Decimal Places 6
Decimal places in mail merge 1
Number of decimal places output 8
Display numbers to the left of a decimal sign 2
Automatic rounding and placement of decimals. 1
Formatting decimal places 8

Top