Try Format menu then Cells then Custom then Type DD/MM/YY or MM/DD/YY
--
Richard


"Harley" wrote:

Hi

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.

Cheers