| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to change date 20080115 to 15/01/2008?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change date 20080115 to 15/01/2008?
Try this, with your number in A1:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) Hope this helps. Pete On Jun 25, 7:01*am, Soozler wrote: |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to change date 20080115 to 15/01/2008?
Data/ Text to Columns/ Delimited/ Next/ Next/ Date : YMD
And next time, please ask the question in the message body, not just in the subject line. -- David Biddulph "Soozler" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| (Fussball Spiel EM 2008) [0/3] - "Fussball Spiele EM 2008.nzb" yEnc (1/1) | Excel Discussion (Misc queries) | |||
| (Fussball Spiel EM 2008) [1/3] - "Fussball Spiele EM 2008.sfv" yEnc (0/1) | Excel Discussion (Misc queries) | |||
| (Fussball Spiel EM 2008) [1/3] - "Fussball Spiele EM 2008.sfv" yEnc (1/1) | Excel Discussion (Misc queries) | |||
| (Fussball Spiel EM 2008) [2/3] - "Fussball Spiele EM 2008.par" yEnc (1/1) | Excel Discussion (Misc queries) | |||
| 6/30/2008 date error?! | Excel Discussion (Misc queries) | |||
Hybrid Mode
