Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a csv file which when opened with excel shows dates as 15041978 or
4051949. I am struggling to convert these to the normal format 15/04/1978 or 04/05/1949. Any suggestions. TIA |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Maybe a formula of
=DATE(RIGHT(A1,4),MID(A1,LEN(A1)-5,2),LEFT(A1,LEN(A1)-6)) -- __________________________________ HTH Bob "Robin Gray" wrote in message et... I have a csv file which when opened with excel shows dates as 15041978 or 4051949. I am struggling to convert these to the normal format 15/04/1978 or 04/05/1949. Any suggestions. TIA |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
a tiny trick to make the parsing easier:
In B1: =IF(LEN(A1)=8,A1,"0" & A1) in C1: =DATE(RIGHT(B1,4),MID(B1,3,2),LEFT(B1,2)) Format as you like. -- Gary''s Student - gsnu2007k "Robin Gray" wrote: I have a csv file which when opened with excel shows dates as 15041978 or 4051949. I am struggling to convert these to the normal format 15/04/1978 or 04/05/1949. Any suggestions. TIA |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks Guys
"Robin Gray" wrote in message et... I have a csv file which when opened with excel shows dates as 15041978 or 4051949. I am struggling to convert these to the normal format 15/04/1978 or 04/05/1949. Any suggestions. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Date Formatting | Excel Worksheet Functions | |||
Formatting as date | Excel Worksheet Functions | |||
Date formatting | Excel Discussion (Misc queries) | |||
Help with formatting the date. | Excel Discussion (Misc queries) |