|Subject:||RE: Date query?|
|Date:||Thu, 11 May 2006|
Try Format menu then Cells then Custom then Type DD/MM/YY or MM/DD/YY
> I have a spreadsheet where I keep a record of client visits.
> I enter the date of visit in Column A i.e 10/5/06 yet when I press enter to
> accept it the date changes in the cell to 05/10/06?
> Grateful for any advice.
Date query? posted by Harley on Thu, 11 May 2006