software

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 quot;04quot; in number format, which means 4?

Cheers
SunnyHi
Just use =A1 in B1 and format B1 as dd

Andy.

quot;DB Explorerquot; gt; wrote in message oups.com...
gt; Hi
gt;
gt; This might be a very simple question to most of you, but I am a novice
gt; user.
gt;
gt; If A1 has date in the format 04-Jan-06, then how do I have B1 display
gt; only the first two characters quot;04quot; in number format, which means 4?
gt;
gt; Cheers
gt; Sunny
gt;
Thanks Andy,

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

THis is a bit cumbersome, but it works:
=VALUE(TEXT(A1,quot;ddquot;))

Andy.

quot;DB Explorerquot; gt; wrote in message oups.com...
gt; Thanks Andy,
gt;
gt; This works, and displays 04, but I am unable to use this for
gt; mathematical functions, it needs to be a number format
gt;
Thanks Andy, this works perfectly, fine.

SunnyHi Sunny

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

--
Regards

Roger Govierquot;DB Explorerquot; gt; wrote in message oups.com...
gt; Thanks Andy, this works perfectly, fine.
gt;
gt; Sunny
gt;
I knew there would be a smarter way!!

Andy.

quot;Roger Govierquot; gt; wrote in message
...
gt; Hi Sunny
gt;
gt; Or you could simplify it to just =DAY(A1)
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;DB Explorerquot; gt; wrote in message
gt; oups.com...
gt;gt; Thanks Andy, this works perfectly, fine.
gt;gt;
gt;gt; Sunny
gt;gt;
gt;
gt;