Re: $$Excel-Macros$$ make 10 digit data

2014-08-03 Thread Ashish Kumar
Hi, PFA...!! Regards Ashish On 3 August 2014 21:36, my excel wrote: > Sir, > i have a excel file its contains customer mobile no > > ex: > >Jan Feb Mar . etc 919845098450 09888021555 9.19293E+11 > 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 >

$$Excel-Macros$$ VBA questions

2014-08-03 Thread kapil Gupta
Hello, Please solve this VBA Question paper As soon as possible. Please find the attached files and check. Regards, Kapil Gupta -- 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://www.fa

Re: $$Excel-Macros$$ Date addition required

2014-08-03 Thread Bé Trần Văn
In Cell (C5:Z13) type: NN (Think 1 day), N (Think again day), Y (Dates of Rest) to see results 2014-08-03 14:17 GMT+07:00 Rajeev : > Dear Experts, > > > > I need help that in my worksheet Where I entered dates (Sheet1) in column > A, in column B I have entered “Y” as working days and “N” as no

$$Excel-Macros$$ make 10 digit data

2014-08-03 Thread my excel
Sir, i have a excel file its contains customer mobile no ex: Jan Feb Mar …. ….. etc 919845098450 09888021555 9.19293E+11 919899989696 9.19845E+11 9.19845E+11 09595959595 +919449449460 9845098430 9845098430 94949494949 [image: Inline image 1] Q: how to convert to 10 digit mobile no ? i

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2014-08-03 Thread Kathy Griffee
I am not the greatest at coding, but this is sheer genius for me. I have gotten it to work in a similar workbook with great results. My question to this old thread is this: I have about 7 different worksheets of lists. List 1 is used to autocomplete cells c7,c18,c19,c25 in the master sheet.

$$Excel-Macros$$ Date addition required

2014-08-03 Thread Rajeev
Dear Experts, I need help that in my worksheet Where I entered dates (Sheet1) in column A, in column B I have entered "Y" as working days and "N" as not working days. Now I need in another sheet (sheet2) if I enter in A1 suppose any date it should add 10 days excluding not working days and