Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel
I need to change the data I exported from Access from
5061988 to 05/06/88. Is there a way to do this in either access or Excel? |
#2
|
|||
|
|||
Say your value is in A1, then enter in B1
=DATEVALUE(RIGHT(A1;4)&"."&LEFT(A1;1)&"."&MID(A1;2 ;2)) Then format B1 as date (mm/dd/yy) Regards, Stefi €˛CHARI€¯ ezt Ć*rta: I need to change the data I exported from Access from 5061988 to 05/06/88. Is there a way to do this in either access or Excel? |
#3
|
|||
|
|||
I'm not sure if your input might include dates in months 10, 11, or 12. If
so, assuming these would be in the format 10061988, for example, you could use: =DATE(RIGHT(A1,4),LEFT(A1,LEN(A1)-6),MID(A1,LEN(A1)-5,2)) where A1 holds the input (can be in general or text format). Then apply date formatting as desired. "CHARI" wrote: I need to change the data I exported from Access from 5061988 to 05/06/88. Is there a way to do this in either access or Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |