UK date format

[Tracey_Harding]

Before you all yell - yes I know the US format is more logical. BUT I build spreadsheets for a UK company. If the admin staff enter 1/2 then they want it to show as February 1st not January 2nd. I can cope and just enter it "wrong" so that it comes out right, but mistakes are possible this way and I want to make it as easy as possible for the users so they only have to use their default brain settings. On my old PC I formatted the cells to work in the UK format. Now with Mac and Office 2008 I can't figure it out. Please help.

 

[Tracey_Harding]

Good grief, I've figured it out for myself. If anyone else needs to know - this is what happens. A cell formatted as dd/mm/yyyy will return the US format. So a Brit entering 1/2 and expecting to see 01/02/2008 will get 02/01/2008 instead. Troublesome. The answer is to add ;@ at the end, so the format should be dd/mm/yyyy;@ then Excel will read the UK entry.