Date Formating
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?
|