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
Hello All,
I am using Excel 2010 version and I need clarification w.r.t =now()
function.
In one cell, I can use the =now() to get August after formatting the
cell under "Custom" and changing the Type to
My query:
1. Can I get August 2011 (not just August-11 which can be obtained unde