If you want to avoid confusing, try spelling the month with a format like:

mmmm dd, yyyy
or
dd mmm yyyy



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

--

Dave Peterson