change (rotate) text format from 2012.05.04 in this format 04.05.2012 (Rotate text)

[johan12]

Hello, I export SMS from my Phone in .CSV Format and wher i export data is in this format 2012.05.04 And I want to change (Rotate) in this format 04.05.2012 , I want to see first Day not Year.

Is there any way to do it.

Thank You.

[singerj6]

Assuming the original date is in A1, put this in B1 and copy down:

=MID(A1,9,2)&"."&MID(A1,6,2)&"."&LEFT(A1,4)

[johan12]

singerj6 Thank you this is work, but problem is after data rotate I need to copy in onother Excel File, I copy from .CVS in onother excel file.

[singerj6]

You could Copy > Paste Special > Values the rotated column over the original column and delete the added column.

[johan12]

Thank you singerj6, Is Work Prefect.