Re: $$Excel-Macros$$ Date format

Hi VBA considering it as mdy format.. Use format function to switch format.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 29, 2014 at 3:01 PM, saravanan R wrote: > Hi Team, > > I have an query on replace "." with "/" in the Data pulled from

$$Excel-Macros$$ Date format

Hi Team, I have an query on replace "." with "/" in the Data pulled from SAP . Actually Format is, 01.12.2014 17.12.2014 WHen I Do Manually Find & Replace, It show me as , 1/Dec/14 17/Dec/14. But when I do through VBA COde, I replace as, 12/Jan/14 "INVALID DATE FORMAT) Can You please check in

Re: $$Excel-Macros$$ Date Format Query

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

Re: $$Excel-Macros$$ Date Format Query

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

Re: $$Excel-Macros$$ Date Format Query

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> >

Re: $$Excel-Macros$$ Date Format Query

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

Re: $$Excel-Macros$$ Date Format Query

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

Re: $$Excel-Macros$$ Date Format Query

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

Re: $$Excel-Macros$$ Date Format Query

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

Re: $$Excel-Macros$$ Date Format Query

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

$$Excel-Macros$$ Date Format Query

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

Re: $$Excel-Macros$$ Date Format conversion

thanks to your replay yes I am using this approach too ,but in some condition I need help in date conversion Thanks again... Thanks & Regards, Rupesh On Tue, Dec 3, 2013 at 11:07 PM, Sam Mathai Chacko wrote: > Why don't you use a date picker? Better yet, a custom non-activex date > picker? >

Re: $$Excel-Macros$$ Date Format conversion

Why don't you use a date picker? Better yet, a custom non-activex date picker? On Tue, Dec 3, 2013 at 10:46 PM, Rupesh Patil wrote: > since long time i guess no buddy have solution for it > thanks experts > > > On Wed, Nov 27, 2013 at 9:43 AM, Rupesh Patil > wrote: > >> Hi Expert >> >> I need a

Re: $$Excel-Macros$$ Date Format conversion

since long time i guess no buddy have solution for it thanks experts On Wed, Nov 27, 2013 at 9:43 AM, Rupesh Patil wrote: > Hi Expert > > I need a help for date conversion, let me explain my task, I have one > userform with 10 multipage and each page have at list one date > field(textbox), what

$$Excel-Macros$$ Date Format conversion

Hi Expert I need a help for date conversion, let me explain my task, I have one userform with 10 multipage and each page have at list one date field(textbox), what i want is user can enter whatever date format he want but i want convert that format "DD-MMM-" so please help me out, How can i do

Re: $$Excel-Macros$$ Date format system using VBA

please share ur vba code with example sheet . Enjoy Team XLS On Thu, Oct 10, 2013 at 6:39 AM, Viswanathan Yoganathan < viswanathan.yoganat...@asia.xchanging.com> wrote: > Hi, > > I am copying the date as text from one sheet and pasting to another sheet > using the co

$$Excel-Macros$$ Date format system using VBA

Hi, I am copying the date as text from one sheet and pasting to another sheet using the code activesheet.paste. when i do it so, it is converting to general number 41135. after formatting to d/mm/, the date that is having greater than 12 get converted exactly to d/mm/ where as date tha

Re: $$Excel-Macros$$ Date Format

Dear Prabhakar, It could be helpful. please find solved attachment and confirm is it ok or not? Regards, Waseem Saifi On Tue, Aug 6, 2013 at 10:52 AM, wrote: > Dear Team, > > I have dates in different format and need to make it in one standard date > format. Please help me to fix this. > > R

$$Excel-Macros$$ Date Format

Dear Team, I have dates in different format and need to make it in one standard date format. Please help me to fix this. Rgds, Prabhakar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://ww

Re: $$Excel-Macros$$ Date format to be changed

Date: Sat, Jun 22, 2013 at 5:51 PM > Subject: Re: $$Excel-Macros$$ Date format to be changed > To: excel-macros@googlegroups.com > > > Dear Pravin : > > Use the below > =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")​ > > > On Sat, Jun 22, 2013 at 3:

Re: $$Excel-Macros$$ Date format to be changed

ere after long time.. > > Regards > Pravin Gunjal. > > -- Forwarded message -- > From: Ahmed Honest > Date: Sat, Jun 22, 2013 at 5:51 PM > Subject: Re: $$Excel-Macros$$ Date format to be changed > To: excel-macros@googlegroups.com > > > Dear Pravi

Fwd: $$Excel-Macros$$ Date format to be changed

Dear Ahmed, Thanks it's working fine.. Nice to see you here after long time.. Regards Pravin Gunjal. -- Forwarded message -- From: Ahmed Honest Date: Sat, Jun 22, 2013 at 5:51 PM Subject: Re: $$Excel-Macros$$ Date format to be changed To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Date format to be changed

orwarded message -- > From: VBA VABZ > Date: Sat, Jun 22, 2013 at 3:38 PM > Subject: Re: $$Excel-Macros$$ Date format to be changed > To: "excel-macros@googlegroups.com" > > > Select cell, right click, format cell, custom & type DD--. > > You c

Fwd: $$Excel-Macros$$ Date format to be changed

Dear Vaibhav It's not working,. please check the attachment. Thanks, Pravin. -- Forwarded message -- From: VBA VABZ Date: Sat, Jun 22, 2013 at 3:38 PM Subject: Re: $$Excel-Macros$$ Date format to be changed To: "excel-macros@googlegroups.com" Select cell, righ

Re: $$Excel-Macros$$ Date format to be changed

Select cell, right click, format cell, custom & type DD--. You can use text(cell,"DD-MMM-") also. Thanks On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote: > I have date in this format : *DD.MM.* (with dot) and require it as : * > DD-MMM-* (with hyphen). > For example :

$$Excel-Macros$$ Date format to be changed

I have date in this format : *DD.MM.* (with dot) and require it as : * DD-MMM-* (with hyphen). For example : I have* 01.04.2013* and want it to be displayed as * 01-APR-2013* Kindly give me the formula. Thanks Regards Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ DATE FORMAT QUERY........

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

Re: $$Excel-Macros$$ Date Format query.......

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

Re: $$Excel-Macros$$ Date Format query.......

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

Re: $$Excel-Macros$$ Date Format query.......

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-

Re: $$Excel-Macros$$ Date Format query.......

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,

$$Excel-Macros$$ Date Format query.......

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

$$Excel-Macros$$ Date Format

Dear All, I have date format as 190410, Can I get date format like 19/04/10. Is there any function can be used. please assist me 190410 70510 40610 60710 220910 101210 80211 240211 140311 80711 180811 31011 7 160112 70312 Regards Manjunath

$$Excel-Macros$$ date format

Hi Excel Experts, I have attached excel sheet for different date format. In this i need to convert date into excel date format or any other alternative way to calculate difference between two dates in different formats. i have welcome ur post / updates thanks in advance. M Solaiyappan -- Join

Re: $$Excel-Macros$$ Date format change by running the macro

... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ankur Sent: Tuesday, June 12, 2012 11:22 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format change by running the macro Thanks Don Sir Very Nice Code But it is not limited to Selected

Re: $$Excel-Macros$$ Date format change by running the macro

With End With End Sub ‘==== Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: ankur Sent: Tuesday, June 12, 2012 5:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format change by running the macro hi Experts i use this code to solve the q

Re: $$Excel-Macros$$ Date format change by running the macro

Dear Ankur, Please if you don't mind will you make your font sytle and size as a simple Or plain one. It looks too ODD. Thanks for your understanding. Regards, On Tue, Jun 12, 2012 at 11:38 AM, ankur wrote: > *HI ASHISH > **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbec

Re: $$Excel-Macros$$ Date format change by running the macro

*HI ASHISH **I TRIED THIS CODE FOR YOUR SOLUTION ,BUT IT IS NOT SO GOODbecause i dont know* how to stop the code after the blank cellsExperts will guide me in this issue how to remove this flawfile is attached for your reference * Sub chgDateFormat() ActiveCell.Offset(0, 1).Range("

Re: $$Excel-Macros$$ Date format change by running the macro

Hi Select the range and run this macro Sub kTest() Dim x With Selection x = .Address .Value = Evaluate("if(isnumber(" & x & "),TEXT(" & x & ",""\-00\-00"")+0," & x & ")") .NumberFormat = "dd-mmm-" End With End Sub Kris ExcelFox

Re: $$Excel-Macros$$ Date format

>>>> -- >>>> On Tue, Jun 5, 2012 at 11:41 AM, LAKSHMAN PRASAD < >>>> lakshman_...@yahoo.com> wrote: >>>> >>>>> C the att. >>>>> >>>>> >>>>> >>>>> >>>>> *F

Re: $$Excel-Macros$$ Date format

> Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Tue, Jun 5, 2012 at 11:41 AM, LAKSHMAN PRASAD > wrote: > >> C the att. >> >> >> >> >> *From:* Lokesh Loki >> *To:* excel-macr

Re: $$Excel-Macros$$ Date format

> *To:* excel-macros@googlegroups.com > *Sent:* Monday, June 4, 2012 6:48 PM > *Subject:* $$Excel-Macros$$ Date format > > Hi Experts, > > I want to confirm the date format whether it is showing Indian date format > or us date format. > > Please send me the formula, > >

Re: $$Excel-Macros$$ Date format

C the att.       From: Lokesh Loki To: excel-macros@googlegroups.com Sent: Monday, June 4, 2012 6:48 PM Subject: $$Excel-Macros$$ Date format Hi Experts, I want to confirm the date format whether it is showing Indian date format or us date format. Please

Re: $$Excel-Macros$$ Date format calculation

t;> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan >> *Sent:* 04 June 2012 6:48 >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Date form

Re: $$Excel-Macros$$ Date format calculation

ajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 04 June 2012 6:48 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Da

RE: $$Excel-Macros$$ Date format calculation

@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format calculation Sir, i mean the times are like wise: hour, minute, second It can be 2000 hours can be 300 mins can be 200 seconds... Thanks & Regards, Deba Ranjan P On Mon, Jun 4, 2012 at 6:29 PM, Rajan_Verma w

Re: $$Excel-Macros$$ Date format

so. (i.e Month/Date/Year) or > (Date/Month/Year). > > Let me know any clarification guys. > > Regards > Lokesh.M > > > > > > > -- Forwarded message -- > From: Rajan_Verma > Date: Mon, Jun 4, 2012 at 6:51 PM > Subject: RE: $$Excel-Macr

RE: $$Excel-Macros$$ Date format

kesh Loki Sent: 04 June 2012 7:09 To: excel-macros@googlegroups.com Subject: Fwd: $$Excel-Macros$$ Date format Hi Experts, Suppose date is 06/04/2012 then i need a output like this (Month/Date/Year) only not for (June/Monday/2012). 06 is showing as Month, 04 is showing as Date, 2012 is showi

Fwd: $$Excel-Macros$$ Date format

the date format is so and so. (i.e Month/Date/Year) or (Date/Month/Year). Let me know any clarification guys. Regards Lokesh.M -- Forwarded message -- From: Rajan_Verma Date: Mon, Jun 4, 2012 at 6:51 PM Subject: RE: $$Excel-Macros$$ Date format To: excel-macros@googlegroups

RE: $$Excel-Macros$$ Date format

Or you can use this in Custom format: -- Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: 04 June 2012 6:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros

RE: $$Excel-Macros$$ Date format

Use this =TEXT(B3,"mmm--") Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: 04 June 2012 6:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ D

Re: $$Excel-Macros$$ Date format

=TEXT(B3,"/dd/") On Mon, Jun 4, 2012 at 6:48 PM, Lokesh Loki wrote: > Hi Experts, > > I want to confirm the date format whether it is showing Indian date format > or us date format. > > Please send me the formula, > > Regards > Lokesh > > -- > FORUM RULES (986+ members already BANNED for

$$Excel-Macros$$ Date format

Hi Experts, I want to confirm the date format whether it is showing Indian date format or us date format. Please send me the formula, Regards Lokesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

Re: $$Excel-Macros$$ Date format calculation

t; * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 04 June 2012 9:27 > > *To:* excel-macros@googlegroups.

RE: $$Excel-Macros$$ Date format calculation

But how can second be 64? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deba Ranjan Sent: 04 June 2012 9:27 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Date format calculation

RE: $$Excel-Macros$$ Date format calculation

groups.com Subject: Re: $$Excel-Macros$$ Date format calculation Dear Asa, Can you please explain in the sheet itself. Thanks & Regards, Deba Ranjan P On Mon, Jun 4, 2012 at 1:22 PM, Asa Rossoff wrote: Hi Deba, For the Login Time column, the reason SUM is not working pr

Re: $$Excel-Macros$$ Date format calculation

r) > > ** ** > > *For the Login time for 1 day… cell* (F5), I don't really understand the > formula or what you want, but perhaps the formula is correct and you just > need to format the result for time: > > [h]:mm:ss > > ** ** > >

RE: $$Excel-Macros$$ Date format calculation

f Deba Ranjan Sent: Saturday, June 02, 2012 12:09 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date format calculation Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Pl

Re: $$Excel-Macros$$ Date format calculation

M-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan >> *Sent:* 02 June 2012 12:39 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Date format ca

Re: $$Excel-Macros$$ Date format calculation

; > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Deba Ranjan > *Sent:* 02 June 2012 12:39 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros

RE: $$Excel-Macros$$ Date format calculation

cel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date format calculation Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Please help in calculating the problem. Thanks &

$$Excel-Macros$$ Date format calculation

Dear Experts, i have again got confusion in date and time format calculation, Please see the attached file, i have elaborate the details in the sheet. Please help in calculating the problem. Thanks & Regards, *Deba Ranjan P* -- FORUM RULES (986+ members already BANNED for violation

Re: $$Excel-Macros$$ date format

Sam Awesome as always! Thanks again On Feb 27, 2012, at 10:30 AM, Sam Mathai Chacko wrote: > No it isn't, it's just that it's a safe practice Maries > > On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote: > Hi Sam, > > Is "Double Minus" required? > > > On Mon, Feb 27, 2012 at 5:47 PM, Sam M

Re: $$Excel-Macros$$ date format

OK Thanks SAM. On Mon, Feb 27, 2012 at 7:30 PM, Sam Mathai Chacko wrote: > No it isn't, it's just that it's a safe practice Maries > > > On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote: > >> Hi Sam, >> >> Is "*Double Minus" *required? >> >> >> On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko

Re: $$Excel-Macros$$ date format

No it isn't, it's just that it's a safe practice Maries On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote: > Hi Sam, > > Is "*Double Minus" *required? > > > On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko wrote: > >> Hi Lee, >> >> =WEEKNUM(--TEXT(A1,"\/00\/00")) >> >> >> http://www.excelfox.c

Re: $$Excel-Macros$$ date format

Hi Sam, Is "*Double Minus" *required? On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko wrote: > Hi Lee, > > =WEEKNUM(--TEXT(A1,"\/00\/00")) > > > http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ > > In your case, I'd use > > * > =TEXT(--TEXT(A1,"\/00\/00"

Re: $$Excel-Macros$$ date format

Hi Lee, =WEEKNUM(--TEXT(A1,"\/00\/00")) http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ In your case, I'd use * =TEXT(--TEXT(A1,"\/00\/00"),"mmm")&"-W"&WEEKNUM(--TEXT(A1,"\/00\/00")) * to give *Oct-W41* Regards, Sam Mathai Chacko On Mon, Feb 27, 201

Re: $$Excel-Macros$$ date format

Hi Sara, Addition in Venkat Formula : For weeknum =WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) For Month =MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV wrote: > Hi , > > Try This, > > > *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* > > *Best Reg

Re: $$Excel-Macros$$ date format

Hi , Try This, *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee wrote: > i have date in this format-- 20011012... yrmmdd.. i want to extract

Re: $$Excel-Macros$$ Date format

Thanks alot On 18 January 2012 18:04, NOORAIN ANSARI wrote: > For more details you can click on.. > > http://www.excelbanter.com/showthread.php?t=270957 > > > > > On Wed, Jan 18, 2012 at 9:33 PM, NOORAIN ANSARI > wrote: > >> Dear Vijay, >> >> For Excel 2007+, you can use conditional formatting.

Re: $$Excel-Macros$$ Date format

Dear Vijay, Without using conditonal Formating.. you can use simple A1=TEXT(A1," d") &LOOKUP(DAY(A1),{1,2,3,4,21,22,23,24,31;"st","nd","rd","th","st","nd","rd","th","st"})&TEXT(A1," , ") -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Date format

dguille...@gmail.com From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ Sent: Wednesday, January 18, 2012 9:45 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Date format Dear Experts How can I change the date in excel as per following format (1st, 2nd, 3rd,4th ) 1st Januar

Re: $$Excel-Macros$$ Date format

For more details you can click on.. http://www.excelbanter.com/showthread.php?t=270957 On Wed, Jan 18, 2012 at 9:33 PM, NOORAIN ANSARI wrote: > Dear Vijay, > > For Excel 2007+, you can use conditional formatting. > > > Let us assume you are formatting M1 > > Select M1 > Format/cells/Number/Cu

Re: $$Excel-Macros$$ Date format

Dear Vijay, For Excel 2007+, you can use conditional formatting. Let us assume you are formatting M1 Select M1 Format/cells/Number/Custom Type: dt\h Then select Conditional Formatting: New Rule Formula: =OR(DAY(M1)=3,DAY(M1)=23) Format/Number/Custom Type: d\r\d New Rule Fo

$$Excel-Macros$$ Date format

Dear Experts How can I change the date in excel as per following format (1st, 2nd, 3rd,4 th ) 1st January, 2012 2nd January, 2012 3rd January, 2012 4th January, 2012 I shall be thankful if anybody can assist Regards V.Kiran Kumar -- FORUM RULES (986+ members already BANNED for violatio

$$Excel-Macros$$ Date Format

Dear Experts, How to convert these "text dates" into date format. e.g. mm-dd- 10-14-2011 Secondly, if "text dates" are not in proper format e.g. dd-mm- 15-4-11 06-05-2011 08-1-2011 formula required. Regards, Aamir Shahzad -- FORUM RULES (934+ members already BANNED for violation)

Re: $$Excel-Macros$$ date format changes

to calculate age of vehicle... > > ** ** > > Regards, > > *Amit Desai* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* 16 November 2011 13:00 > *To:* excel-macros@goo

RE: $$Excel-Macros$$ date format changes

@googlegroups.com Subject: Re: $$Excel-Macros$$ date format changes Dear Amit, Please try this formula. =TEXT(A5,"dd-mmm-yy") in vba, You can use Function Date_format(rng As Range) Date_format = VBA.Format(rng, "dd-mmm-yy") End Function -- Thanks & rega

Re: $$Excel-Macros$$ date format changes

Dear Amit, Please try this formula. =TEXT(A5,"dd-mmm-yy") in vba, You can use Function Date_format(rng As Range) Date_format = VBA.Format(rng, "dd-mmm-yy") End Function -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://n

$$Excel-Macros$$ date format changes

Dear All, How can i change 01/25/2011 to 25-Jan-2011 with a formula.. i have tried changing it with text to column (date option)... also done format cell option..but could not work... Regards, Amit Desai Disclaimer: This message and its attachments contain conf

Re: $$Excel-Macros$$ date format in Excel

Hi Sanjib, If it is real date then sir dguillett suggestion will work fine... --- Ms.Exl.Learner --- On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear > > I like to put the date format in Excel as "dd/mm/yyy

Re: $$Excel-Macros$$ date format in Excel

Select cell or column then right click format cell ...then in number tab go to date and select date format then ok On Fri, Sep 30, 2011 at 11:03 AM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear > > I like to put the date format in Excel as "dd/mm/",

Re: $$Excel-Macros$$ date format in Excel

If ??? I understand, simply CUSTOM format the cell as "dd-mm- From: Sanjib Chatterjee Sent: Friday, September 30, 2011 12:33 AM To: excel-macros Subject: $$Excel-Macros$$ date format in Excel Dear I like to put the date format in Excel as "dd/mm/", and like to get the

Re: $$Excel-Macros$$ date format help

use this formula : =TEXT(C1,"dd-mmm-") On Thu, Sep 29, 2011 at 11:45 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear All members, > > please help me regarding date format in Excel. > > I want to put the value in excel as "dd/mm/", but like to get the value > as "dd-mm

Re: $$Excel-Macros$$ date format in Excel

rote: > > Dear all members > > please help to solve the problem > > Sanjib > > -- Forwarded message -- > From: Sanjib Chatterjee > Date: Fri, Sep 30, 2011 at 11:03 AM > Subject: $$Excel-Macros$$ date format in Excel > To: excel-macros > >

Fwd: $$Excel-Macros$$ date format in Excel

Dear all members please help to solve the problem Sanjib -- Forwarded message -- From: Sanjib Chatterjee Date: Fri, Sep 30, 2011 at 11:03 AM Subject: $$Excel-Macros$$ date format in Excel To: excel-macros Dear I like to put the date format in Excel as "dd/mm/"

Re: $$Excel-Macros$$ Date format

Hi Ashish. Welcome... *Best Regards,* *Venkat* *Chennai* * * On Sat, Jul 30, 2011 at 2:38 PM, Ashish <4everash...@gmail.com> wrote: > Thanks Venkat, the solution works for me. > > Ashish. > > > On Jul 29, 7:14 pm, Venkat CV wrote: > > Hi , > > > > Try the Below you May get the output as requir

Re: $$Excel-Macros$$ Date format

Thanks Venkat, the solution works for me. Ashish. On Jul 29, 7:14 pm, Venkat CV wrote: > Hi , > > Try the Below you May get the output as required... > > =TEXT(A1,"DD-MM-YY") > > *Best Regards,* > *Venkat* > *Chennai* > * > * > > On Fri, Jul 29, 2011 at 5:25 PM, Ashish Khandelwal > <4everash..

Re: $$Excel-Macros$$ Date format

Hi , Try the Below you May get the output as required... =TEXT(A1,"DD-MM-YY") *Best Regards,* *Venkat* *Chennai* * * On Fri, Jul 29, 2011 at 5:25 PM, Ashish Khandelwal <4everash...@gmail.com>wrote: > Hi, > > I have a date string in the format of dd-mm-. I want to change in the > dd-mm-yy.

Re: $$Excel-Macros$$ Date format

t; As long as ever you can.” - John Wesley > *--------- > > > -- > *From:* Ashish Khandelwal <4everash...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Fri, July 29, 2011 7:55:1

Re: $$Excel-Macros$$ Date format

From: Ashish Khandelwal <4everash...@gmail.com> To: excel-macros@googlegroups.com Sent: Fri, July 29, 2011 7:55:11 AM Subject: $$Excel-Macros$$ Date format Hi, I have a date string in the format of dd-mm-. I want to change in the dd-mm-yy.

$$Excel-Macros$$ Date format

Hi, I have a date string in the format of dd-mm-. I want to change in the dd-mm-yy. The Output should be like 29-07-11 Please help. Thanks & Regards, Ashish Khandelwal. -- -- Some important links for excel

Re: $$Excel-Macros$$ date format

Tnanx!! for ur kind resoponse. Regards, Deepak On Tue, Jul 20, 2010 at 12:21 PM, Prashant Jadhav < prashantjadhav...@gmail.com> wrote: > Dear Deepak, > > 1st thing is you have to replace (//) with single (/) and have to insert > date with dd/mm/ format and not mm/dd/ > > Your prob will g

Re: $$Excel-Macros$$ date format

e, if that's what you need. > > Regards - Dave. > > Date: Tue, 20 Jul 2010 11:46:49 +0530 > Subject: $$Excel-Macros$$ date format > From: deepakexce...@gmail.com > To: excel-macros@googlegroups.com > > Hi all > > My problem is, there is a field Date i want to chan

RE: $$Excel-Macros$$ date format

ay, Month, Year). A macro could be written to change it to Date, if that's what you need. Regards - Dave. Date: Tue, 20 Jul 2010 11:46:49 +0530 Subject: $$Excel-Macros$$ date format From: deepakexce...@gmail.com To: excel-macros@googlegroups.com Hi all My problem is, there is a

Re: $$Excel-Macros$$ date format

Dear Deepak, 1st thing is you have to replace (//) with single (/) and have to insert date with dd/mm/ format and not mm/dd/ Your prob will get resolved -- Regards, Prashant On Tue, Jul 20, 2010 at 11:46 AM, Deepak Rawat wrote: > Hi all > > My problem is, there is a field *Date*

$$Excel-Macros$$ date format

Hi all My problem is, there is a field *Date* i want to change the format of all the dates. I used alt+shift+# but all dates are not changing then i tried to value them but the problem remains same. file is attached. Could u pls tell the exect problem with the data. Regards, Deepak -- -

RE: $$Excel-Macros$$ Date format problem

f unwanted formats. Once XL has converted data to a date, it is a pain in the neck to get it to convert it back. Regards - Dave. Date: Fri, 27 Nov 2009 16:10:12 +0530 Subject: $$Excel-Macros$$ Date format problem From: 7jit...@gmail.com To: excel-macros@googlegroups.com Good Evening Excel Gurus,

Re: $$Excel-Macros$$ Date format problem

If it has already been converted into date format and you want to reverse it, use =Text(date,"yy-mm-dd") or =Text(date,"dd-mm-yy") the way you want and then remove formulae by pasting only the values Hemant Hegde 2009/11/27 Norman May > Jitesh > > Try formatting the cells as TEXT > > Norma

Re: $$Excel-Macros$$ Date format problem

Jitesh Try formatting the cells as TEXT Norman On Fri, Nov 27, 2009 at 5:40 AM, Jitheesh Vazhapully <7jit...@gmail.com>wrote: > Good Evening Excel Gurus, > > I have a data in this format 01-01-01, however as soon as I enter them in > the excel sheet,excel picks it up as date and stores it in d

  1   2   >