Fwd: $$Excel-Macros$$ CHANGE DATE FORMAT

for convert to number format ... u also use ''--'' befor formula like =--TEXT(B2,"-00-00") On Sat, Jan 21, 2012 at 11:40 AM, Ashish Bhalara wrote: > Thanks a lot for formula, could you please explain the means of "+0" in > the end of formula? > > Thanks from Ashish. > > > On Sat, Jan 21, 2012

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

Thanks a lot for formula, could you please explain the means of "+0" in the end of formula? Thanks from Ashish. On Sat, Jan 21, 2012 at 10:29 AM, chandra sekaran wrote: > > try this > > =TEXT(TEXT(B3,"-00-00"),"DD-MM-") > > chandru > > > > On Sat, Jan 21, 2012 at 10:16 AM, xlstime wrote

RE: $$Excel-Macros$$ Excel - Array Help

Dear All, Can someone please explain how the below formula will work & I mean what logic it will follow. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 20 January 2012 16:22 To: excel-macros@googlegroups.com Subj

$$Excel-Macros$$ Proportionate calculation

Dear Experts I am attaching an excel form, in which according to the promotion date text box the proportionate pay text box has to show in the command button event the pay of that particular month according to the days calculation. eg. if the pay is 1000/- pm (consider every calendar month shoul

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

try this =TEXT(TEXT(B3,"-00-00"),"DD-MM-") chandru On Sat, Jan 21, 2012 at 10:16 AM, xlstime wrote: > or try this one.. for any format > > =TEXT(B2,"-00-00")+0 > > > On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote: > >> Hi Ashish, >> >> use this formula (if you date format is sa

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

or try this one.. for any format =TEXT(B2,"-00-00")+0 On Sat, Jan 21, 2012 at 10:14 AM, xlstime wrote: > Hi Ashish, > > use this formula (if you date format is same 20120121 ) > > *=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B2,2)))* > > > On Sat, Jan 21, 2012 at 9:50 AM, As

Re: $$Excel-Macros$$ CHANGE DATE FORMAT

Hi Ashish, use this formula (if you date format is same 20120121 ) *=DATEVALUE(CONCATENATE(LEFT(B2,4),"-",MID(B2,5,2),"-",RIGHT(B2,2)))* On Sat, Jan 21, 2012 at 9:50 AM, Ashish Bhalara wrote: > Dear experts, > > I want to change date format from 20120121 or 21012012 to 21-Jan-2012, > because ex

$$Excel-Macros$$ CHANGE DATE FORMAT

Dear experts, I want to change date format from 20120121 or 21012012 to 21-Jan-2012, because excel not count as an date format if I replace "-" or "/" character between date,month and year. Is there any function to convert this type of number in proper date format? Because this type of date genera

Re: $$Excel-Macros$$ Hidden file

this are the temp files..not possible to UNHIDE but try to use *attrib -s -h -r* in cmd use:- press window+r button for run then type cmd and then type atrib -s -h -r then enter On Fri, Jan 20, 2012 at 12:29 PM, Neeraj Chauhan wrote: > Dear sir, > > ** ** > > Kindly see the attached scr

Re: $$Excel-Macros$$ Copy data from excelsheet to html file

Hi Rajan, We have one 5 to 6 fields like name, number, address and zip code etc... and we have to add that data on client web site. can you please suggest the VBA codes so that i can apply this on our excel sheet and modify as per the requirement. due to client web site (process application) i can

Re: $$Excel-Macros$$ Need to Change Date Format

Dear Imran, Please use =TEXT(A1,"mm/dd/yy hh:mm:ss AM/PM") On Fri, Jan 20, 2012 at 10:10 PM, Imran khan wrote: > Dear All, > > I have Date in A1 = 20-Jan-12, I want in B1 =mm/dd/yy hh:mm:ss AM/PM > format (1/20/2012 7:00:00 AM) > > Please give me formula. > > regards, > Imran > > -- > FORUM RUL

$$Excel-Macros$$ Need to Change Date Format

Dear All, I have Date in A1 = 20-Jan-12, I want in B1 =mm/dd/yy hh:mm:ss AM/PM format (1/20/2012 7:00:00 AM) Please give me formula. regards, Imran -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

RE: $$Excel-Macros$$ Copy data from excelsheet to html file

Hi It can be through excel.. which is that web site and how much data you have to enter In online Form..?? Regards Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sushil Kumar Sent: Jan/Fri/2012 07:50 To: excel-macros@googlegroups.com Subject: R

Re: $$Excel-Macros$$ Copy data from excelsheet to html file

Hi Rajan, I Don't want to convert the file; however i just want to input the data from the sheet into the "specific" web site. here at my office some of my team members work is to enter some data which is in excelsheet on the web site. Thank you in advance. Sushil. On Fri, Jan 20, 2012 at 5:35 P

Re: $$Excel-Macros$$ RE: Array Help

many -2 thanks to all of u -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't p

Re: $$Excel-Macros$$ FW: Hidden file

go to run type cmd @command prompt type attrib -r -s -h -a filename -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick atte

Re: $$Excel-Macros$$ query about translate

use http://translate.google.co.in/ On Fri, Jan 20, 2012 at 6:26 PM, Rajan_Verma wrote: > I think no way in excel without use of any other software > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *anil kumar

RE: $$Excel-Macros$$ query about translate

I think no way in excel without use of any other software Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Fri/2012 06:12 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query about translate I want to t

Re: $$Excel-Macros$$ Save As today date

Dear Darwin, It is working fine on my system, we can use below code in this format for dynamic path.. Sub savemethod() Dim todaydate As String Dim fileSaveName As String Path = VBA.InputBox("Enter Path") todaydate = VBA.Format(DateSerial(Year(Date), Month(Date), Day(Date)), "dd-mmm-") fileSav

Re: $$Excel-Macros$$ query about translate

Dear Noorain   Anil want to do like under written   Jh yksds'k dqekj vxzoky  to  Shri Lokesh Kumar Aggarwal From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Friday, 20 January 2012 2:13 PM Subject: Re: $$Excel-Macros$$ query about transla

RE: $$Excel-Macros$$ Need looping in VB script

Try this: Sub LoopingAllFileInAFolder() Dim strPath As String Dim fso As Scripting.FileSystemObject Dim fldFolder As Folder Dim flFile As File Set fso = New Scripting.FileSystemObject With Application .FileDialog(msoFileDialogFolderPicker).Show

Re: $$Excel-Macros$$ query about translate

I want to translate all name and add. in english anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may

Re: $$Excel-Macros$$ EXCEL - TIPS

thanx noor From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Friday, 20 January 2012 11:20 AM Subject: Re: $$Excel-Macros$$ EXCEL - TIPS Dear Kishore, You can study attached Ebook step by step.. It will help you to learn excel. - Thanks & regar

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Try this one: Sub isExist() On Error Resume Next If WorksheetFunction.Match(Range("rngValues").Value, Range("List"), 0) Then If Err.Number = 1004 Then Err.clear On error goto 0:on Error Goto -1 MsgBox "Values not found" Else MsgBox Range("rngValues").Value

Re: $$Excel-Macros$$ FW: Hidden file

Dear Neeraj, Once again try through.. Control Panel-Folder Options then view. It may be help to you. On Fri, Jan 20, 2012 at 1:27 PM, Neeraj Chauhan wrote: > Dear All, > > ** ** > > Kindly see the snap carefulle hiddin opetion is hidden. Why it not showing > and I can’t click on it > >

RE: $$Excel-Macros$$ Copy data from excelsheet to html file

HI Do you want to convert you data in xml? Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sushil Kumar Sent: Jan/Thu/2012 02:00 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Copy data from excelsheet to html file Hi, Ple

RE: $$Excel-Macros$$ Required Unique Words.

Try this VBA Function : Paste it in a VBA module and use Function ExtractUnique(rng As Range) As String Set rng = Range("a1") Dim objDic As Object Set objDic = CreateObject("Scripting.Dictionary") For i = 1 To Len(rng.Value) If Not objDic.Exists(Mid(rng.V

RE: $$Excel-Macros$$ query about translate

Do you want to translate data or just want to change format ?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Fri/2012 04:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query about translate Yes sir, this s

RE: $$Excel-Macros$$ code

Try this : =REPLACE(REPLACE(A1,3,2,"."),6,5,".") From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Jan/Thu/2012 09:56 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ code I want to change this column A to column G (means

RE: $$Excel-Macros$$ Required Unique Words.

Hi Noorain.. Its not static .. text can be change.. need a dynamic solution Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Jan/Fri/2012 03:39 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Uniqu

Re: $$Excel-Macros$$ query about translate

Yes sir, this same file, How can i do plz tell me. I have to translate that data in english Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ Excel - Array Help

Dear Sourabh, Please use this one to find unique value of more than one column without using helping column *=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,"Duplicate","Unique") * See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra wrote: > Thank you so much sir, if we want with

Re: $$Excel-Macros$$ Required Unique Words.

Dear Raghu, I hope your requirement is this one..* =(LEN(A1)-LEN(SUBSTITUTE(A1,"gole","")))/LEN(B2)* See attached sheet. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Required Unique Words.

Dear Experts, I want to take unique words from A1 cell. please suggest -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get

RE: $$Excel-Macros$$ Vlookup Help

I just use indirect function to get reference from another sheets, well we can use this long formula also J Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Bhalara Sent: Jan/Thu/2012 09:22 To: excel-macros@googlegroups.com Subject: Re

RE: $$Excel-Macros$$ Macro for inserting columns and fill with strings

Try this One: Sub MyTest() Dim wksSheet As Worksheet Set wksSheet = ThisWorkbook.Worksheets("Sheet1") Application.screenUpdating=False With wksSheet .Range("D2").Formula = "=LEFT(A2,FIND(""U"",A2,1))" .Range("E2").Formula = "=RIGHT(A2,LEN(A2)-LEN(D2))"

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Thank you very much for the prompt action. It works as per my requirement. Have a wonderful day! On Fri, Jan 20, 2012 at 2:56 PM, PrIyAnKa wrote: > Dear Sunita > > Kindly find the attached file > > Hope this is as per your req > > > 2012/1/20 सुनिता पौडेल > >> Dear Priyanka, >> >> Thank you fo

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

Dear Sunita Kindly find the attached file Hope this is as per your req 2012/1/20 सुनिता पौडेल > Dear Priyanka, > > Thank you for the interest shown. Please find attached the example of what > I required. > > > > > On Fri, Jan 20, 2012 at 1:12 PM, PrIyAnKa wrote: > >> Dear Sunita >> >> Kindly

Re: $$Excel-Macros$$ Pivot Table (URGENT)

You are welcome On Fri, Jan 20, 2012 at 2:23 PM, Mahreen Ellahi wrote: > Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) > > > On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa wrote: > >> Dear Mahreen >> >> Kindly find the attached file and see the yellow highlighted row ,i

RE: $$Excel-Macros$$ regarding rounding off

Its logical. =IF(VALUE(RIGHT(INT(A2),1))>0,INT(A2)+(10-VALUE(RIGHT(INT(A2),1))),INT(A2)) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Jan/Wed/2012 04:58 To: Paul Schreiner; excel-macros@googlegroups.com Subject: $$Excel

Re: $$Excel-Macros$$ Pivot Table (URGENT)

Hey thanks Priyanka, it workss perfectly the way I wanted to thanks alot :) On Fri, Jan 20, 2012 at 12:20 PM, PrIyAnKa wrote: > Dear Mahreen > > Kindly find the attached file and see the yellow highlighted row ,i have > did the same w/o pivot > > > > On Thu, Jan 19, 2012 at 11:12 PM, Mahreen Ell

Re: $$Excel-Macros$$ query about translate

Dear Anil, Attached file format is same as you posted previous. All Fonts are in Hindi. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Fri, Jan 20, 2

Re: $$Excel-Macros$$ Need help on Resigned staffs statistic

fyi regards jitendra singh 9015340017 On Fri, Jan 20, 2012 at 12:57 PM, PrIyAnKa wrote: > Dear Sunita > > Kindly give one example of what u want in your sheet as to study the data > and analyse the same and preparing format as per your requirement takes a > lot time > > So kindly provide one ou

$$Excel-Macros$$ query about translate

hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, lik