Date transscription

[willem1933]

I receive my bank statements with the date written as: yyyymmdd
This notation is without dots or slashes. I can use the replace command to put a dot or a slash behind the year, but do not know how to put on between the month and the day. Have tried to use macro, but when I do the cursor springs back to the cell I made the macro in.
I want my dates as dd.mm.yyyy
Suggestions please

 

[VoG]

Try like this - you can format B1 as you wish

Excel Workbook
	A	B
1	20111029	29.10.2011
Sheet1

 

[pgc01]

Hi

To convert the string to a date you can also use:

=TEXT(A1,"0000-00-00")+0

and then format the cell as you wish

 

[willem1933]

Thanks for the help both from VoG, the moderator and PGC01.

The answer from VoG did alas not work

I succeeded with the conversion via =TEXT(A1,"0000-00-00")+0, then with copy-paste special-values converted it to text. After this I used =datevalue which converted it to a number (hidden in a formula). Converted the formula again with copy-paste special-values and converted it to text. Then formated the text number into the european date format.

Thanks