Table column with date field

[crookesa]

I have a table created with one empty row at the start and one of the columns is a date in the format dd/mm/yyyy
When a user inputs data and tabs down to create a new row the date column reverts back to mm/dd/yyyy

Is there a reason for this even though I have set the format of the initial row, I thought all formatting and formulae would copy down?

 

[sandy666]

change system date format to dd/mm/yyyy

 

[crookesa]

Is that a windows setting or within excel?

 

[sandy666]

if you have Windows so this is a Windows settings (system)

 

[crookesa]

Thanks for that, I checked the regional and system settings and both are set to the expected date format of dd/mm/yyyy.
So must be something else causing it?

 

[sandy666]

select your date column and use

then re-enter dates and (if necessary) set short date format dd/mm/yyyy

 

[crookesa]

I'll try that thanks, I have some conditional formatting go on too in the cells so need to try preserve them

 

[sandy666]

IMHO if something taking your time more than 10 minutes re-build all from the beginning