Please find attached
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pravin Gunjal
Sent: 14 June 2013 12:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Date conversion to other format
Hi,
I want to convert the date =Today() to
refer..
On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote:
> Hi,
>
> I want to convert the date =Today() to this format : DD.MM.
>
> Formula =Today() 6/14/2013 In next cell, it should display as :
> 14.06.2013
> Sample file is attached. Thanks.
>
> Regards
> Pravin Gunnjal
>
> --
>
Dear Pravin
try it
=TEXT(TODAY(),"dd.mm.")
or
select cell and press ctrl+1 and type in custom format dd.mm.
On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote:
> Hi,
>
> I want to convert the date =Today() to this format : DD.MM.
>
> Formula =Today() 6/14/2013 In next cel
