"Mel" wrote:

One of our users has an excle worksheet with three date columns all fomatted
as date. Formattig being used is 2/22/07 for example. However for all three
columns when you type in the required date of say 2/22/07 and hit enter, it
defaults to 01/00/00. It defaults to 01/00/00 in each cell for these three
date columns. How can I fix this?

Additionaly - One of my date columns are G196 however column J has a formula
of =IF(G196="",C196,0) and column L has a forumla of
=IF(H196="",C196,0)-IF(G196="",C196,0). Both column J and L affect my date
column G196.