Changing monthy format from US to UK

[davidx]

Hi,

Does anybody know how to translate dates which i already have in the US format, to the UK format.

i.e. mm/dd/yy becomes dd/mm/yy

Thanks

[Fotis1991]

Are these real dates and not TEXT that looks like date? In this case(if are really dates) you shouldn't have problem..

[Ursul]

If your computer/laptop Regional Settings are set up as UK then you should not have any issues. With the cell/s selected press Ctrl+1, the Format Cells dialog box opens, under the Number tab, select Date and under Locale9location): select English (UK)

[davidx]

ok thanks very much