Suddenly unable to re-format cells

G

Guest

I've been having a WEIRD problem with my Excel spreadsheets. I set up my
2006 workbook for my business after the first of the year and all was well.
I have columns that show check numbers (whole numbers) and those kept
entering fine...in the past three weeks when I enter a new check number...it
adds decimal points. I know how to highlight the cell and re-format it, but
it will not allow me to re-format. Also, the other day I went into one of my
old workbooks that is a listing of names and addresses and I changed one
address and when I tried to change the zip code...it added two decimal places
there as well.

Do you have ANY idea what's going on and how I can fix it? Thanks!
 
G

Guest

Click on TOOLS, OPTIONS and click on the EDIT tab. Turn of the number of
Fixed decimal.
 
G

Guest

Thank you Kevin...that worked BEAUTIFULLY! I do wonder how it was locked in
the first place but at least now I know how to correct it!
Joodie
 

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