Simple Question, display only part of a date in Number format

Hi

This might be a very simple question to most of you, but I am a novice
user.

If A1 has date in the format 04-Jan-06, then how do I have B1 display
only the first two characters "04" in number format, which means 4?

Cheers
Sunny

Hi
Just use =A1 in B1 and format B1 as dd

Andy.

"DB Explorer" <sunilkeswani@gmail.com> wrote in message
news:1142590566.608896.166940@p10g2000cwp.googlegroups.com...
> Hi
>
> This might be a very simple question to most of you, but I am a novice
> user.
>
> If A1 has date in the format 04-Jan-06, then how do I have B1 display
> only the first two characters "04" in number format, which means 4?
>
> Cheers
> Sunny
>

Thanks Andy,

This works, and displays 04, but I am unable to use this for
mathematical functions, it needs to be a number format

Hi

THis is a bit cumbersome, but it works:
=VALUE(TEXT(A1,"dd"))

Andy.

"DB Explorer" <sunilkeswani@gmail.com> wrote in message
news:1142590928.327674.190950@p10g2000cwp.googlegroups.com...
> Thanks Andy,
>
> This works, and displays 04, but I am unable to use this for
> mathematical functions, it needs to be a number format
>

Thanks Andy, this works perfectly, fine.

Sunny

Hi Sunny

Or you could simplify it to just =DAY(A1)

--
Regards

Roger Govier


"DB Explorer" <sunilkeswani@gmail.com> wrote in message
news:1142592144.168587.317490@j33g2000cwa.googlegroups.com...
> Thanks Andy, this works perfectly, fine.
>
> Sunny
>