$$Excel-Macros$$ How to split cell in Excel

2013-05-27 Thread Prathap
Hi Experts, How do we split a cell in excel in to two where one part of text is vertical aligned and other is being horizontal aligned. Pls help Best Regards, PRATHAP D M +91 9899-370-328 -- 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

$$Excel-Macros$$ How to embed an Outlook mail into excel

2011-11-14 Thread Prathap
HI All, I`m trying to embed the Outlook mail into a cell in Microsoft excel (2010) through Insert object. However after embedding, object is not showing the outlook icon rather than dispalying as blank object. Attached is the sample file. Best Regards, PRATHAP D -- FORUM RULES (934+ members

Re: $$Excel-Macros$$ Urgent Help required

2011-10-13 Thread Prathap
Thank you all for your assistance. However i have a sheet (containing 67 columns & 3980 rows) were i need to change the entire cell into million. Attached is the sample sheet Best Regards, PRATHAP D M +91 9899-370-328 On 13 October 2011 20:22, Prathap wrote: > Hi, > > Is t

$$Excel-Macros$$ Urgent Help required

2011-10-13 Thread Prathap
Hi, Is there a way to convert all the cells with numbers in to million format with shortcut / formula. Example: 1232345487 i want as 1232. Attached is the sample file Best Regards, PRATHAP D M +91 9899-370-328

$$Excel-Macros$$ Fomula to find the Missing Numbers in the sequence - Reg

2011-02-28 Thread Prathap
Dear All, I have an excel sheet in which i need to find the missing numbers in the sequence. Please help me with the formula to identify missing numbers in a list of consecutive numbers. Example : Best Regards, Prathap

Re: $$Excel-Macros$$ Assistance Required

2010-08-11 Thread Prathap
Thanks dude. It works. Best Regards, PRATHAP D M +91 9899-370-328 On 9 August 2010 19:26, Bruno Bruno wrote: > My friend Prathap, > > Yes, there is. I did it in the Sample I am returning to you, but I would > strongly recommend other simpler ways to do it. > > The point i

$$Excel-Macros$$ Assistance Required

2010-08-08 Thread Prathap
employee. Thanks in advance. Best Regards, PRATHAP D M +91 9899-370-328 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Assistance required

2010-04-04 Thread Prathap
September & October remains 0 unit and additional stock of 20 units were received in the month of october which makes closing balance to 120 in the month of October without any consumption. I hope you understand my requirement. Thanks in advance Thanks & Regards, Prathap.D prathap@g

Re: $$Excel-Macros$$ Assistance required

2010-04-02 Thread Prathap
& Regards, Prathap.D prathap@gmail.com +919899370328 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook G

$$Excel-Macros$$ Assistance required

2010-04-02 Thread Prathap
& Regards, Prathap.D prathap@gmail.com +919899370328 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook G

$$Excel-Macros$$ Password Cracker file

2010-01-05 Thread Prathap .
Hi There.. I have excel file which is protected. Can anyone please help crack the password. If possible, then pls tell me. Keeping the confidentiality in to consideration i can mail the excel file to the concerned . Thanks in advance -- ---