Changing date styles

[BrianHall]

Good morning,

Can someone tell me how to change a euro date style of 20131109 in one cell (cell A1) to a standard date stlye as 11/9/2013 in another cell (Cell B1)?

Thank you

 

[lexxie2013]

One way is format A1 as custom format yyyymmdd

Format B1 as short date

in B1 enter the formula:

=A1

 

[BrianHall]

Never mind..

I just used the following formula in cell B1.

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

Works great now.

Thanks