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!

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


"Joodie" wrote:

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!

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

"Kevin B" wrote:

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


"Joodie" wrote:

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!