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

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

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

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

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

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

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

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 :

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,

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

Hi Noorain, Thanks for resolving the query. i got exact results in the cells. Have a great future ahead. Once again thanks for spending a valuable time for me. Regards Lokesh.M On Thu, Jun 7, 2012 at 5:10 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please find Formula in attached workbook. >

Re: $$Excel-Macros$$ Date format

Hi Noorain, Thanks for resolving my small query. Now i got the exact result. Thanks a lot have a great future ahead. Regards Lokesh.M On Thu, Jun 7, 2012 at 3:49 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please find attached Sheet, Hope it will help to you. > > > -- > Thanks & regards, > No

Re: $$Excel-Macros$$ Date format

Dear Lokesh, Please find attached Sheet, Hope it will help to you. -- 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-macros@googlegroups

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 se

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

Date: Mon, Jun 4, 2012 at 6:51 PM Subject: RE: $$Excel-Macros$$ Date format To: excel-macros@googlegroups.com Or you can use this in Custom format: -- Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.co

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$$ Date format H

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

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

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 properly is > that many of the login times are being in

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

Hi Deba, For the Login Time column, the reason SUM is not working properly is that many of the login times are being interpreted as text instead of as [h]:mm:ss entries. 1) For the login time column with a custom format: [h]:mm:ss or the corresponding preset "Time" format: 37:30:55 2)

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

Please have a look on this Dear Experts. Thanks & Regards, *Deba Ranjan P* On Mon, Jun 4, 2012 at 9:27 AM, Deba Ranjan wrote: > Yes...exactly. > > > Thanks & Regards, > *Deba Ranjan P* > > > > > > On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma wrote: > >> Hi >> >> What do you

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

Yes...exactly. Thanks & Regards, *Deba Ranjan P* On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma wrote: > Hi > > What do you mean by this Login time : “879:55:64” is it 879 Hour 55 > Minute and 64 Seconds?? > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [I

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

Hi What do you mean by this Login time : "879:55:64" is it 879 Hour 55 Minute and 64 Seconds?? Regards 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@go

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

number =A1&MID("thstndrdth",MIN(9,2*RIGHT(A1)*(MOD(A1-11,100)>2)+1),2) Date =TEXT(A4,", d")&MID("thstndrd",(MOD(DAY(A4),10)*AND(MOD(DAY(A4),10)<4,OR(DAY(A4)<11,DAY(A4)>20)))*2+1,2) Don Guillett SalesAid Software dguille...@gmail.com From: ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar

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

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

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 output as "dd-mm

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

Dear Sanib Da, Please use below formula and see attached sheet. * =TEXT(MID(A2,FIND("/",A2,1)+1,2)&"-"&LEFT(A2,FIND("/",A2,1)-1)&"-"&RIGHT(A2,LEN(A2)-FIND("/",A2,FIND("/",A2,1)+1)),"dd-mmm-") * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

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

*right click on cell go to format go to custom format and then type as DD/MM/* *you will get it what you are expecting :)* ** On Fri, Jul 29, 2011 at 7:14 PM, Paul Schreiner wrote: > Does Excel recognize the dd-mm- as a valid DATE? > > That is: Can you change the format to "long date" fo

Re: $$Excel-Macros$$ Date format

Does Excel recognize the dd-mm- as a valid DATE? That is: Can you change the format to "long date" format and it automatically changes 29-07-2011 to "Friday, July 29, 2011" If so, then excel recognizes the string as a "date", Technically, there are two types of "dates"... 1) A string of ch

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

Hi Simply replace "//" by "/" and do the formatting, I don't think anything else needs to be done for this. Regards Rajender Soni On Jul 20, 1:33 pm, Dave Bonallack wrote: > Hi Deepak, > > Not quite sure what's wrong, but some of the data in Col C has a double // > between the year and month.

RE: $$Excel-Macros$$ date format

Hi Deepak, Not quite sure what's wrong, but some of the data in Col C has a double // between the year and month. Also, it's coming up on my system as Month, Day, Year, which means XL doesn't recognise it as a Date. (If it did, it would display it according my local settings, Day, Month, Year)

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*

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

Hi Jitesh, Format the cells as 'Text' before entering your data. However, if your data is imported, or if you are pasting it from another place, it may bring formatting with it. If you are pasting it from another place, use Paste Special, then Values. This will prevent the pasting of unwanted fo

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

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

Type it as '01-01-01 On Fri, Nov 27, 2009 at 5:40 PM, 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 date format, Is > there any wa