Dear All,

I have faced with a problem what I can't solve. The problem is that the report which is coming from SAP contains a date in the following format: 26/10/2011
This is text format and there is not any opporunity to change the format into real and manageable date format. I tried to use format change (text to date), some date related functions to convert it, but it is not working.
Do you have any idea how I can change this SAP date format into excel date format?
Many thanks for your help in advance!

Bence