Re: $$Excel-Macros$$ Need Power point code help

2012-04-01 Thread rekha siri
hi Ashish, Thanks for your link however i am unable to download macro file it is stating Macro file not found. Can you please forward that macro file. Thanks, Rekha On Sun, Apr 1, 2012 at 6:33 PM, ashish koul wrote: > http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-6.html > > > On

Re: $$Excel-Macros$$ Re: format a cell

2012-04-01 Thread pawel lupinski
Hi Again, Thanks again, it's all working, I have a lot to learn what is great, you've shown me the magic. thanks Pawel From: pawel lupinski To: "excel-macros@googlegroups.com" Sent: Sunday, April 1, 2012 10:45 PM Subject: Re: $$Excel-Macros$$ Re: format a

Re: $$Excel-Macros$$ Re: format a cell

2012-04-01 Thread pawel lupinski
HI ALL in first words I'd like to thanks you all ever so much for so many replies. Its great to see how many different (great) solution is for one query. I've learn a lot and I'm so thankful for your help. I'll try all your helpful solution. Again thanks a lot. Pawel ___

$$Excel-Macros$$ Format Conversation Question

2012-04-01 Thread qcan
Hi, There is probably a very simple solution here, but I am stumped. In this link below, you will see a table that has a field called "TOI" (abbreviation for time on ice). The number is visually set up as minutes and seconds. When I bring this into excel, I am unable to convert this into

RE: $$Excel-Macros$$ Re: sumproduct.xlsx

2012-04-01 Thread finos
Thanks for reply . its good for me From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 31 March 2012 22:24 To: finos; excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: sumproduct.xlsx Don Guillett Microsoft MVP Excel Sale

$$Excel-Macros$$ Re: format a cell

2012-04-01 Thread Haseeb A
Hello Pawel, Another one. =TEXT(A1*IF(ISNUMBER(FIND(".",A1)),100,1),"00\:00") If you want to enter 2 for 2'O clock enter as 200 or cell format as text then enter like 2.00 ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titl

Re: $$Excel-Macros$$ Need Power point code help

2012-04-01 Thread ashish koul
http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-6.html On Sun, Apr 1, 2012 at 3:04 PM, rekha siri wrote: > hi Experts, > > i am attaching a macro which copies the two charts from excel and pastes > in ppt. > > but can some one help to modify this code to paste two charts in one slide

Re: $$Excel-Macros$$ format a cell

2012-04-01 Thread Maries
*Convert the formula contain cell into Time format* On Sun, Apr 1, 2012 at 4:20 PM, Aamir Shahzad wrote: > Dear Maris - your formula is giving 0.23 result if enter 532, required by > powel was 5:32 > > Aamir Shahzad > > On Sun, Apr 1, 2012 at 4:07 PM, Maries wrote: > >> Hi Pawal, >> >> My tr

Re: $$Excel-Macros$$ format a cell

2012-04-01 Thread Aamir Shahzad
Dear Maris - your formula is giving 0.23 result if enter 532, required by powel was 5:32 Aamir Shahzad On Sun, Apr 1, 2012 at 4:07 PM, Maries wrote: > Hi Pawal, > > My try, > > =IF(ISERROR(FIND(".",A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1," > .",""),""),2),RIGHT(TEXT(SUBSTITUTE(A1,".",""),""

Re: $$Excel-Macros$$ format a cell

2012-04-01 Thread Maries
Hi Pawal, My try, =IF(ISERROR(FIND(".",A1,1)),TIME(LEFT(TEXT(SUBSTITUTE(A1,".",""),""),2),RIGHT(TEXT(SUBSTITUTE(A1,".",""),""),2),0),TIME(TEXT(INT(A1),"00"),(A1*100)-(INT(A1)*100),0)) I have tried with INT formula for decimal entries (For Decimal condition formula shown below) =TIME