I am using Excel 2002 - I have received a worksheet with various dates keyed in by a colleague in USA. For example one of the dates is shown as "12/10/02" which should be viewed at "December 10th, 2002". However when I format the date cell to view the full month it shows as "October 12th, 2002".
Can anyone tell me a way to make the full date format show as its original intented date?
Barrie Bowdler
Can anyone tell me a way to make the full date format show as its original intented date?
Barrie Bowdler