Thanks for your help Sand - I've got them trying this out now.

cheers!
--
Kind regards
Mandy


"mandy" wrote:

I have created a spreadsheet that shows certain dates in the past and future
dictated by inputting one date and is formatted using dd/mm/yyyy. My
colleagues in India are trying to use the sheet too but when using it some of
the fields (not all of them) change to mm/dd/yyyy format. I need to find a
way of formatting it so that they all stay dd/mm/yyyy to avoid confusion -
can anyone help?

Huge thanks in advance
--
Kind regards
Mandy