mmm-
>
>
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Venkat CV
> Sent: Friday, August 05, 2011 5:05 PM
> To: excel-macros@googlegroups.com
> Cc: ashlyprad...@gmail.com
> Subject: Re: $$Excel-Macros$$ Help with =now()
>
>
-macros@googlegroups.com
*Cc:* ashlyprad...@gmail.com
*Subject:* Re: $$Excel-Macros$$ Help with =now()
*Hi Ashish,*
*Yes you can Just Type in Custom "As on" mmm you will get output
as a "As on August 2011"*
*Best Regards,*
*Venkat *
*Chennai*
On Fri, Aug 5, 201
Use this Format :
-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Friday, August 05, 2011 5:05 PM
To: excel-macros@googlegroups.com
Cc: ashlyprad...@gmail.com
Subject: Re: $$Excel-Macros$$ Help with =now()
Hi Ashish
*Hi Ashish,*
*
*
*Yes you can Just Type in Custom "As on" mmm you will get output as
a "As on August 2011"*
*
*
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Fri, Aug 5, 2011 at 4:53 PM, Ashish Pradhan wrote:
> Hello Venkat
>
> Amazing :-)
>
> Wonder why I couldn't think of it earlier :-)
>
>
Hello Venkat
Amazing :-)
Wonder why I couldn't think of it earlier :-)
Is the second part possible. For eg. In the same cell, I want the cell
to display as "As on August 2011" (Where August 2011 will be obtained
using the now() formula as described earlier and as you have suggested..
Thanks
