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
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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> Thanks Andy, this works perfectly, fine.
>
> Sunny
>
I knew there would be a smarter way!!
Andy.
"Roger Govier" <[email protected]> wrote in message
news:[email protected]...
> Hi Sunny
>
> Or you could simplify it to just =DAY(A1)
>
> --
> Regards
>
> Roger Govier
>
>
> "DB Explorer" <[email protected]> wrote in message
> news:[email protected]...
>> Thanks Andy, this works perfectly, fine.
>>
>> Sunny
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks