Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dd/mm/yyy date format
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
How can I convert a date format to an ISO week format (in EXCEL)? | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) |