Hi!
I have a formula that simply refers to a cell with a date. Most of th
time it works fine but on occation it refuses to update and I canno
seem to find the logic. The base cell (A1) says Dec-05 the formula cel
(B1) =A1 says Nov-05. How can this be?

F9 manual Calc does not fix it nor does Tools Options Manua
Calculation
Application.ScreenUpdating = True ' does nothing
Activeworkbook.Precisionasdisplayed = True ' does nothing

The only way I have found to fix it is to edit directly into the cel
or formula bar. If I select the cell and hit F2 and enter then it wil
read OK.

Please help if you can Thank

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=49458