D
davidbeecken
This is a strange problem and searching all over google cant get any
help. There is a row of dates, in format 10/23/1983, we are trying to
change it to another format. When I click the cells properties and
change the format, nothing happens. This includes the "sample section",
the format just does not change. Now here is the really odd part. If I
change the format, click ok, then double click the cell, then single
click on another cell, the format changes to what I wanted, and from
then on it works right for that cell. This seems to be worksheet
specific, because if I add a worksheet, that one will work fine. This
is also happening over multiple workbooks.
just some basic info to keep inmind before replying:
1. Its limited to already made worksheets
2. This document is not protected in anyway, nor is any cell set to
locked
3. This is not just a date related problem, any other cell I try to
format with a different type(say currency) its the same problem.
Thanks for any suggestions.
help. There is a row of dates, in format 10/23/1983, we are trying to
change it to another format. When I click the cells properties and
change the format, nothing happens. This includes the "sample section",
the format just does not change. Now here is the really odd part. If I
change the format, click ok, then double click the cell, then single
click on another cell, the format changes to what I wanted, and from
then on it works right for that cell. This seems to be worksheet
specific, because if I add a worksheet, that one will work fine. This
is also happening over multiple workbooks.
just some basic info to keep inmind before replying:
1. Its limited to already made worksheets
2. This document is not protected in anyway, nor is any cell set to
locked
3. This is not just a date related problem, any other cell I try to
format with a different type(say currency) its the same problem.
Thanks for any suggestions.