I have a three spreadsheets. Each represents a different year and each has
one column with different dates within that year.
Unfortunately I entered all of these dates in the default date format ie
7-jan and did not enter a year. I now need to ensure the year is present in
the date formula in some way ie 07/01/04 or any format that shows the year.
Is there a quick way of changing this rather than retyping all.
--
lucy