This is working perfectly as per my requirement.
Thanks.
Regards
Pravin Gunjal.
On Sun, Jun 15, 2014 at 10:54 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA
MACROS wrote:
> Hi Pravin ...
>
> You can go to Format cell and custom the format of the date which ever
> result you need. furthermore you can
ou
>> can,In all the places you can,At all the times you can,To all the people
>> you can,As long as ever you can.” - John Wesley*
>> ---------
>>
>>*From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS <
>> excel-macr
an,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can." - John Wesley*
> -
>
>*From:* 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS <
> excel-macros@googlegroups.com>
>
can,
As long as ever you can.” - John Wesley
-
From: 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS
>To: "excel-macros@googlegroups.com"
>Sent: Sunday, June 15, 2014 1:24 PM
>Subject: Re: $$Excel-Macros$$ Date Format Query
&g
Hi
You can change display format by going to cell property & select custom and
type dd.mm.
If by doing so if date format does not change then select single column
then press Data tab in Menu then press Next 2 times then select Date (DMY)
and press finish button.
Cheers!!
On Thu, Jun 12, 20
Where have not applying this date format.. Can send u file with mark
area
Pramod
On 14 Jun 2014 10:41, "Pravin Gunjal" wrote:
> Dear Pramod,
>
> Thank you for your reply. But I found it is not giving result for all
> cells.
> Please do the needful.
>
>
> On Thu, Jun 12, 2014 at 4:22 PM, Pra
Dear Pramod,
Thank you for your reply. But I found it is not giving result for all
cells.
Please do the needful.
On Thu, Jun 12, 2014 at 4:22 PM, Pramod Singh wrote:
> Hi
> Pravin Gunjal,
>
> PFA
>
> Hope This will fine for you..
>
>
>
>
> Warm Regards
>
> Pramod
>
> VBA Developer
>
>
> O
Hi
Pravin Gunjal,
PFA
Hope This will fine for you..
Warm Regards
Pramod
VBA Developer
On Thu, Jun 12, 2014 at 3:12 PM, Pravin Gunjal wrote:
> Hi,
>
> I wanted to convert the dates in this format *DD.MM.*
>
> Now it is not in system's date format ( MM/DD/ ) and it is displaye
Hi,
I wanted to convert the dates in this format *DD.MM.*
Now it is not in system's date format ( MM/DD/ ) and it is displayed as
DD/MM/ or as D/M/.
Kindly help.
Regards
Pravin Gunjal.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:I
Hi All,
I want to change date format in MS Access. Please help me.
Date format : mm-dd- & I want to dd-mm-
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print
you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-------------
From: Kuldeep Singh
To: excel-macros@googlegroups.com
Sent: Thu, February 21, 2013 5:31:24 A
are you working with real date or text?
if you r working with text then try the below
=(DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)))+7
or
=TEXT((DATE(RIGHT(A1,4),MID(A1,4,2),LEFT(A1,2)))+7,"DD/MM/)
On Thu, Feb 21, 2013 at 4:01 PM, Kuldeep Singh wrote:
>
> I am already try this =A1+7. this is n
I am already try this =A1+7. this is not working. because date format is
dd/mm/
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-
assuming your date is in a1
=a1+7
On Thu, Feb 21, 2013 at 3:52 PM, Kuldeep Singh wrote:
>
> Hi All,
>
> One instant query. my format is 18/02/2013 & I want to add 7 days. Please
> help
>
> Regards,
> Kuldeep Singh
> Info Edge India Limited (naukri.com)
> Phone.: +91-0120-4841100, Extn.: 2467,
Hi All,
One instant query. my format is 18/02/2013 & I want to add 7 days. Please
help
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print
15 matches
Mail list logo
