RE: change text to real dates
- From: driller <driller@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 4 Oct 2009 03:20:01 -0700
using len() i got all with 8.
from the two formulas suggested, i got same results.
26.04.09---->#value!
11.06.09---->11/6/2009----->06-Nov-09 ??
do i have some difficulty now?
"Mike H" wrote:
Hi,.
I suspect spaces at the start or end, try this
=DATEVALUE(LEFT(TRIM(A1),2)&"/"&MID(TRIM(A1),4,2)&"/"&RIGHT(TRIM(A1),2))
Mike
"driller" wrote:
thanks,
i got #value!.
"Mike H" wrote:
Hi,
Try this
=DATEVALUE(LEFT(A1,2)&"/"&MID(A1,4,2)&"/"&RIGHT(A1,2))
Mike
"driller" wrote:
Hello,
i have extracted text within texts in a column of data thru left & right
function.
then i have the texts result like this
26.04.09
11.06.09
23.06.09
05.07.09
12.07.09
30.09.09
I need to change it to real dates considering that the first 2 digits are
Days and the last 2 digits are Years.
e.g.
26.04.09 ----> 26-Apr-09 or 26/04/09
thanks for helping. Any suggestion is appreciated.
--
regards
- Follow-Ups:
- RE: change text to real dates
- From: Mike H
- RE: change text to real dates
- References:
- change text to real dates
- From: driller
- RE: change text to real dates
- From: Mike H
- RE: change text to real dates
- From: driller
- RE: change text to real dates
- From: Mike H
- change text to real dates
- Prev by Date: RE: change text to real dates
- Next by Date: RE: Is it possible to copywrite a workbook? Or other protection op
- Previous by thread: RE: change text to real dates
- Next by thread: RE: change text to real dates
- Index(es):
Relevant Pages
|
