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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DB Explorer - 17 Mar 2006 11:16 GMT

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

Reply to this Message

AndyB - 17 Mar 2006 11:19 GMT

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

Andy.

> Hi
>
[quoted text clipped - 6 lines]
> Cheers
> Sunny

Reply to this Message

DB Explorer - 17 Mar 2006 11:22 GMT

Thanks Andy,

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

Reply to this Message

AndyB - 17 Mar 2006 11:32 GMT

Hi

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

Andy.

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

Reply to this Message

DB Explorer - 17 Mar 2006 11:42 GMT

Thanks Andy, this works perfectly, fine.

Sunny

Reply to this Message

Roger Govier - 17 Mar 2006 12:38 GMT

Hi Sunny

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

Signature

Regards

Roger Govier

> Thanks Andy, this works perfectly, fine.
>
> Sunny

Reply to this Message

Andy - 17 Mar 2006 12:47 GMT

I knew there would be a smarter way!!

Andy.

> Hi Sunny
>
[quoted text clipped - 3 lines]
>>
>> Sunny

Reply to this Message