I am importing data from a mainframe. Dates are in UK format dd.mm.yyyy
(30.09.2008)

I need to convert to dd/mm/yyyy

Any help appreciated.


Mac

=SUBSTITUTE(A1,".","/")*1
Cell format dd/mm/yyyy
--
Regards.
Daniel
"Mac1" a écrit dans le message de news:
...

I am importing data from a mainframe. Dates are in UK format dd.mm.yyyy
(30.09.2008)

I need to convert to dd/mm/yyyy

Any help appreciated.


Mac

Hi

Select the columnDataText to ColumnsnextnextDateD/ME/IFinish

--
Regards
Roger Govier

"Mac1" wrote in message
...

I am importing data from a mainframe. Dates are in UK format dd.mm.yyyy
(30.09.2008)

I need to convert to dd/mm/yyyy

Any help appreciated.


Mac

Blessed Spell checkers!!!!

Should have read
Select the columnDataText to ColumnsnextnextDateD/M/YFinish

--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

Select the columnDataText to ColumnsnextnextDateD/ME/IFinish

--
Regards
Roger Govier

"Mac1" wrote in message
...

I am importing data from a mainframe. Dates are in UK format dd.mm.yyyy
(30.09.2008)

I need to convert to dd/mm/yyyy

Any help appreciated.


Mac

Thank you Daniel & Roger.

Mac

"Mac1" wrote:


I am importing data from a mainframe. Dates are in UK format dd.mm.yyyy
(30.09.2008)

I need to convert to dd/mm/yyyy

Any help appreciated.


Mac