RE: change text to real dates
- From: Jacob Skaria <JacobSkaria@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 4 Oct 2009 03:52:01 -0700
Yes Mike; an excellent source .... and also a nice way to resolve
disputes!!!.kidding)
"Mike H" wrote:
Jacob,.
I didn't know about this series of clips. An excellent source for beginners,
nice one.
Mike
"Jacob Skaria" wrote:
Watch this 2 min video which will help
http://www.youtube.com/watch?v=24Z8TsyRVsY
If this post helps click Yes
---------------
Jacob Skaria
"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
- References:
- change text to real dates
- From: driller
- RE: change text to real dates
- From: Jacob Skaria
- 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
|
