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

Select one column at a time containing data, then goto Data >> Text to column (or just press Alt + D then E). Select Fixed width & press Next 2 time, now select Date & existing date format viz. DMY for Date-Month-Year and press finish. Cheers!! On Wed, Jul 16, 2014 at 12:22 PM, Ashish Bhalara

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

use this formula : CONCATENATE(DAY(C4),"-",MONTH(C4),"-",YEAR(C4))​ On Wed, Jul 16, 2014 at 9:52 AM, Ashish Bhalara wrote: > Dear experts, > > I have a data in which date format is Text, I want to change in date > format to filter data date and month wise. I have change manually this > thing by

$$Excel-Macros$$ Change date format

Dear experts, I have a data in which date format is Text, I want to change in date format to filter data date and month wise. I have change manually this thing by pressing FR and Enter key. Please provide Macro or function to change the format, the example file is attached herewith. Regards. Ashi

$$Excel-Macros$$ Automatic sum for three month

Dear experts I required formula as like Automatic sum for three month.PFA sheet with detailed Regards Amar -- 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.facebook.com/discussexcel FORU

Re: $$Excel-Macros$$ is it any easy way to import DAT file to Excel

thanks vaibhav :) Warm Regards, Dhaval Shah M) 98240 35253 *E-mail : todhavals...@gmail.com * On Tue, Jul 15, 2014 at 7:43 PM, Vaibhav Joshi wrote: > check this too... > > > http://www.marketcalls.in/spreadsheet/how-to-extract-data-from-nseinda-com-using-google-docs.html > > http://www.mark

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

Thank you all         Delin.F   On Tuesday, 15 July 2014 7:13 AM, XLS S wrote: Dear Delin, Please try below link.  http://www.excel-pratique.com/en/vba.php Its a very useful and simple  . Enjoy Team XLS On Mon, Jul 14, 2014 at 10:56 PM, 'DELIN FRANCIS'

$$Excel-Macros$$ Urgent required QA Engineer/Lead - San Jose, CA

*Please respond to gurjant.si...@damcsooft.com * *Position: QA Engineer/Lead Location: San Jose, CADuration: 6+ Months* *VISA: USC/GC/EAD onlyNeed candidate who can join immediately*JD: • Senior QA lead…with strong Selenium or Silk test “MUST” • Hands on QA lead with strong automation test

Re: $$Excel-Macros$$ Add Control On button click on Page

Thanks Paul, for being with me. I am working on one project called Examination Tool for Doctors. Where doctor can do there consultation using this tool. in this tool have one module and userform call Prescriptions. On this userform doctor may add 2 medicines or may be 10, so I want one row of 5 t

Re: $$Excel-Macros$$ Add Control On button click on Page

 OK, but WHY?   Can you not simply have the userform filled with the appropriate number of boxes and have them turned off? then, when you hit the button, simply change the visibility to "on" (.Visible = true)   ?   I've done it both ways, but only actually create the objects if the number i need

$$Excel-Macros$$ Urgent required Java Developer - Charlotte (NC)

*Please respond to gurjant.si...@damcosoft.com * *Position: Java Developers (RIA Developer)Location: Winston Salem / Charlotte (NC) – 1st Preference: Winston Salem, NCDuration: Long Term* *4 Positions* Technical Skills: •*Java - RIA Developers* •Java, JSP, Servlets, Struts, Javascript

Re: $$Excel-Macros$$ Add Control On button click on Page

Hello Paul, I am so sorry that I am not clear enough. I want add 5 text boxes on each time button click. On Mon, Jul 14, 2014 at 5:13 PM, Paul Schreiner wrote: > I'm sorry, there just doesn't seem to be enough information to figure out > what it is you want to do! > > Are you saying you wish t

Re: $$Excel-Macros$$ is it any easy way to import DAT file to Excel

check this too... http://www.marketcalls.in/spreadsheet/how-to-extract-data-from-nseinda-com-using-google-docs.html http://www.marketcalls.in/spreadsheet/vba-macro-to-download-bhavcopy.html On Tue, Jul 15, 2014 at 7:40 PM, Vaibhav Joshi wrote: > chek this for other way outs... > > > http://

Re: $$Excel-Macros$$ is it any easy way to import DAT file to Excel

chek this for other way outs... http://investmentefforts.blogspot.in/2013/02/learn-to-use-excel-to-get-real-time.html http://www.mrexcel.com/tip103.shtml Cheers!! On Tue, Jul 15, 2014 at 7:35 PM, Dhaval Shah wrote: > Hello friends > > is it any easy way to import Dat file from web to direc

Re: $$Excel-Macros$$ Half day formula

Need More Explain Plzzz With Example ... Warm Regards Pramod On Tue, Jul 15, 2014 at 5:21 PM, Shamugam Pillai wrote: > > > Hi > > First time posting and am not sure if this is the right platform but I > have this attendance template and I'm unsure of how to input the formula > for half day tak

$$Excel-Macros$$ Half day formula

Hi First time posting and am not sure if this is the right platform but I have this attendance template and I'm unsure of how to input the formula for half day taken and the total figure calculated to tally with the half day. Able to help me? Thanks -- Are you =EXP(E:RT) or =NOT(EXP(E:RT))