Re: $$Excel-Macros$$ Querry ncg

Sub test() Dim i As Long, j As Long, k As Long ' change 3 with the row no from which ur data is starting j = 222 For i = 222 To Range("j65356").End(xlUp).Row splt = Split(Application.WorksheetFunction.Trim(Range("k" & i).Value)) For k = LBound(splt) To UBound(splt) Sheets(1).Range("l" & j).V

Re: $$Excel-Macros$$ Unable to change date fromate

A simpler and more direct way would be to use Text To Columns by selecting your date column, and in the column data format, select DMY and finish the conversion. All your text dates would now be actual dates, and you don't require use of any formula. Alternatively, if you would like to use formula

Re: $$Excel-Macros$$ job

2011/10/11 ashish koul > * > ** Email ID -malath...@aarchsol.com* > > *Dear Candidate,* > > Hi, > > We have very good opening with one of our major client., please find the > details. > > Job Location : Bangalore > Experience: 1 - 6yrs > > Description: > Must have experience in MS

Re: $$Excel-Macros$$ Read a menu and produce results

Monizri, 1) So a usedrange is the literally used range of a worksheet. So any sheet that has some kind of data or format is considered as the used range. So if you have data in Range("A1:Z200"), even if some of the cells in between are completely blank, your used range would still be A1:Z200. So i

Re: $$Excel-Macros$$ Unable to change date fromate

Dear Suman, if you interested to use VBA then you can use... *Function Date_format(dt As Date) Date_format = VBA.Format(dt, "mm/dd/") End Function * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogsp

Re: $$Excel-Macros$$ Unable to change date fromate

try =DATE(2000+VALUE(RIGHT(A2,2)),VALUE(MID(A2,4,2)),VALUE(LEFT(A2,2))) Don Guillett SalesAid Software dguille...@gmail.com From: Suman Sent: Tuesday, October 11, 2011 8:08 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Unable to change date fromate Hi, Good eveni

$$Excel-Macros$$ VBA to Check Spelling and Highlight Individual Words

Dear Sir / Madam I have an Excel sheet with VBA which is designed to compare two boxes of text/copy and highlight any differences. The existing code is very good although, it does not currently highlight individual words (it only changes the box color to red to suggest there is an error). Here is

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Hi Try this =text(A2,"000") This will convert in text with format as per your req. If you want same value in number then change the format with to custom 000 Thanks and regards, Somnath C Pardeshi +91 829 111 9311 Sent from my BlackBerry® Smartphone on Loop Mobile. -Original Message-

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Simply CUSTOM format the cells as 000 Don Guillett SalesAid Software dguille...@gmail.com From: waheedb...@gmail.com Sent: Tuesday, October 11, 2011 2:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Prefix "0" before the number- Help Hi group, I have numeric data in col

Re: $$Excel-Macros$$ Urgent Help in a Outlook Macro

See if this link helps http://www.exceltip.com/show_tip/Applications_-_Word,_Outlook_in_VBA/Control_Outlook_from_Excel_using_VBA_in_Microsoft_Excel/464.html Don Guillett SalesAid Software dguille...@gmail.com From: Secret Shot Sent: Tuesday, October 11, 2011 2:35 AM To: excel-macros@googlegrou

$$Excel-Macros$$ Pivot Table data extract

Hi Expert, In Pivot table data details, when we double click on any value the details of those values extract from main database and another worksheet get prepared. In this process, new worksheet details (extracted one) by default extracted in "Table Format" and everytime we have to do "Conver

$$Excel-Macros$$ job

* ** Email ID -malath...@aarchsol.com* *Dear Candidate,* Hi, We have very good opening with one of our major client., please find the details. Job Location : Bangalore Experience: 1 - 6yrs Description: Must have experience in MS-Access. Must have experience in VBA Good knowledg

Re: Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Thnx everyone for u help. On , Swapnil Palande wrote: Hi, You can use Text function. =Text(A1, "000") this formula will convert number into text But if you want to keep it number only then use custom format as per suggested by Noorain On Tue, Oct 11, 2011

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Hi, You can use Text function. =Text(A1, "000") this formula will convert number into text But if you want to keep it number only then use custom format as per suggested by Noorain On Tue, Oct 11, 2011 at 2:09 PM, NOORAIN ANSARI wrote: > Dear Waheed, > > Please use below formula > > *=REPT

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

See if this helps... Best, Manoj Kumar On Tue, Oct 11, 2011 at 1:14 PM, wrote: > Hi group, > > I have numeric data in column, each cell contains 5 to 6 numeric values but > are less 7 characters. > For example: 12345, > 385469. > > What I want is, what ever is the count it should round upto 7

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

hi, Use Text function to prefix 0 before number ex: =TEXT(A1, "000") Pls find attached excel. Regards, Swapnil. On Tue, Oct 11, 2011 at 1:48 PM, karan 1237 wrote: > Hey Waheeb, > > Pls find enclosed. > > > Kaяan > >

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Dear Waheed, Please use below formula *=REPT(0,(7-LEN(A1)))&A1* ** *you can change 7 as per your requirement.* ** *Step-2.* ** *you can also use custom format.* ** *Select cell press ctrl+1 and type 000 in Type Text Box.* ** -- Thanks & regards, Noorain Ansari *http://excelmacroworld.b

Re: $$Excel-Macros$$ Querry ncg

Freinds, In the querry worksheet, the data was in b3 and c3 and result is generated from e3 and f3 , but in actual, my data is available in column J222 and k222 in sheet named "kundali" , and i tried to change the range in Macro but failed. Hence, please send me the details as to where i should c

Re: $$Excel-Macros$$ Prefix "0" before the number- Help

Hey Waheeb, Pls find enclosed. Kaяan

$$Excel-Macros$$ Prefix "0" before the number- Help

Hi group, I have numeric data in column, each cell contains 5 to 6 numeric values but are less 7 characters. For example: 12345, 385469. What I want is, what ever is the count it should round upto 7 characters. Exampl 1): 12345. Result: 0012345. Ex; 2) 384569 Result: 0384569 "0" should be