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

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

Go to the Control Panel and double click the Regional and Language icon. On
the Regional Options tab page, click the CUSTOMIZE button and then click the
DATE tab in the next dialog box. Verify that your short date format is
M/d/yyyy.

--
Kevin Backmann


"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