Date format conversion...

[misio]

Is there a way to convert date from a European format (yy/mm/dd) to mm/dd/yyyy format used in the US? I have a spreadsheet that was created on a computer with Regional Settings configured as the UK.

Thanks

 

[Yogi Anand]

On 2002-03-27 13:22, misio wrote:
Is there a way to convert date from a European format (yy/mm/dd) to mm/dd/yyyy format used in the US? I have a spreadsheet that was created on a computer with Regional Settings configured as the UK.

Thanks

Hi misio:
Of course! The numbers behind the dates don't change -- just the format changess
So select the date cell then FORMAT|CELLS|NUMBER|Date ... then look at all the options you have for formatting!

 

[BabyTiger]

Hi,

Assuming the date you want to convert is in cell A1, and the format of that date is 'yy/mm/dd', and also your computer's regional setting is US, ie your date would be mm/dd/yy.

Then, the following formula might help you:
=date(left(a1,2),mid(a1,4,2),right(a1,2))

The above date is formula is based on =date(year,month,date), so you can adjust the length of your substring.

HTH