Hi,
use this :
=TEXT(A1,"mm")
On Fri, Apr 19, 2013 at 6:14 PM, colmkav wrote:
> Hi,
>
> what excel formula do I need to convert a date field into the month number
> like 03 for March?
>
> for example cell A3= #31/03/2013#
>
> I want "03" in my new cell.
>
>
> Colm
>
>
>
> --
> Are you =EXP(E:
hi
if data is in date format then, use =text(cellref,"mm")
Thanks
On Fri, Apr 19, 2013 at 6:14 PM, colmkav wrote:
> Hi,
>
> what excel formula do I need to convert a date field into the month number
> like 03 for March?
>
> for example cell A3= #31/03/2013#
>
> I want "03" in my new cell.
>
>
try this =MONTH(A1) if its stored as date
if its stored ad text like this #31/03/2013# then try =MID(A2,5,2)
Regards
Ashish
On Fri, Apr 19, 2013 at 6:14 PM, colmkav wrote:
> Hi,
>
> what excel formula do I need to convert a date field into the month number
> like 03 for March?
>
> for exam
Hi,
what excel formula do I need to convert a date field into the month number
like 03 for March?
for example cell A3= #31/03/2013#
I want "03" in my new cell.
Colm
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Fac
