Percentage format

D

dpal

I have this workbook that was working fine. Now every new and old cell
changes everything to a percentage. Even if I make a new sheet in that
workbook.
ex. When I put 100 in a cell it changes it to look like 10. Or if I put in
10 it changes it to .1. What happened and how do I change this back?


Dpal
 
F

FSt1

hi
not sure. guessing here but....
2003
on the meun bar>tools>options>edit tab>uncheck fixed decimal places
2007
Office button>Excel Options>Advanced tab>Uncheck "Automatically insert a
decimal point"

regards
FSt1
 

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

Top