Prev: Autofilter header row
Next: IF nested problem ..!
From: Dave Peterson on 10 Apr 2010 16:32
Just to add to David's response...

I'm amazed at how many different string formats excel can see as a date. It
comes in particularly handy when doing data|text to columns.



Eric wrote:
>
> Wow! magic, I don't know why it works this way, but it works beautifully
> Do you have any suggestions on how it works this way?
> Thank everyone very much for suggestions
> Eric
>
> "Dave Peterson" wrote:
>
> > If your abbreviations are nice, you could use a formula like:
> >
> > =month("1"&A1)
> >
> > If your abbreviations aren't nice, it won't work.
> >
> >
> >
> > Eric wrote:
> > >
> > > Does anyone have any suggestions on how to convert text "JAN" into number 1?
> > > Does excel have any built in function to do it?
> > > For all the months' symbol into numbers
> > > "JAN" into 1
> > > ..
> > > "MAR" into 3
> > > ..
> > > "DEC" into 12
> > >
> > > Does anyone have any suggestions?
> > > Thanks in advance for any suggestions
> > > Eric
> >
> > --
> >
> > Dave Peterson
> > .
> >

--

Dave Peterson
First  |  Prev  | 
Pages: 1 2 3
Prev: Autofilter header row
Next: IF nested problem ..!