Thread
:
Date Conversion
View Single Post
#
2
Posted to microsoft.public.excel.misc
Daniel.C
external usenet poster
Posts: 43
Date Conversion
=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
Reply With Quote
Daniel.C
View Public Profile
Find all posts by Daniel.C