Prev: More than selected rows being highlighted
Next: MS Query results into merged rows
From: FSt1 on 15 Mar 2010 14:36
hi
to prevent confusion on my last post.
for today =Month(A2) will return 3 (for third month-Mar)

regards
FSt1

"FSt1" wrote:

> hi
> =month(a2)
>
> will return 3 (third month)
>
> Regards
> FSt1
>
> "Kennedy" wrote:
>
> > Is there a way to convert a numeric date 03/01/2010 into a single month
> > function? I have a worksheet that pulls in data from another worksheet, and
> > column A has a numeric date of 03/01/2010. Want to put a statement in column
> > B or where that only shows the month instead of the whole date field.
From: FSt1 on 15 Mar 2010 16:05
hi
i think dave peterson answered your question about 10 posts ago.
find and replace.
press Ctlr+F
click the replace tab.
in the find box enter . (dot)
in the replace box enter : (colon)
click replace all

Regards
FSt1

"Kennedy" wrote:

> Is there a way to convert a numeric date 03/01/2010 into a single month
> function? I have a worksheet that pulls in data from another worksheet, and
> column A has a numeric date of 03/01/2010. Want to put a statement in column
> B or where that only shows the month instead of the whole date field.
From: FSt1 on 15 Mar 2010 16:31
ignore the above. posted to wrong post.

sorry
FSt1

"FSt1" wrote:

> hi
> i think dave peterson answered your question about 10 posts ago.
> find and replace.
> press Ctlr+F
> click the replace tab.
> in the find box enter . (dot)
> in the replace box enter : (colon)
> click replace all
>
> Regards
> FSt1
>
> "Kennedy" wrote:
>
> > Is there a way to convert a numeric date 03/01/2010 into a single month
> > function? I have a worksheet that pulls in data from another worksheet, and
> > column A has a numeric date of 03/01/2010. Want to put a statement in column
> > B or where that only shows the month instead of the whole date field.
From: Kennedy on 16 Mar 2010 10:26
Thanks everyone for the advice. I think the issue may have been with the fact
that the column was being pulled from another sheet source. So between
everyone's suggestion, was able to use =text(column,"MMM") and it worked
perfectly. Thanks again for all of the input...and I rated all the replies

"Kennedy" wrote:

> Is there a way to convert a numeric date 03/01/2010 into a single month
> function? I have a worksheet that pulls in data from another worksheet, and
> column A has a numeric date of 03/01/2010. Want to put a statement in column
> B or where that only shows the month instead of the whole date field.
First  |  Prev  | 
Pages: 1 2
Prev: More than selected rows being highlighted
Next: MS Query results into merged rows