View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B
 
Posts: n/a
Default Suddenly unable to re-format cells

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!