$$Excel-Macros$$ Re: small issue

2014-12-25 Thread Zafar Iqbal
Format of B5:D5 is TEXT and B7:D7 is General. If Both rows will have same formats then you will get same answer visa vera. On Wednesday, December 24, 2014 2:50:56 PM UTC+3, amar takale wrote: -- 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)

Re: $$Excel-Macros$$ Re: small issue

2014-12-25 Thread amar takale
Dear zafar PFA On Thu, Dec 25, 2014 at 5:17 PM, Zafar Iqbal ziqba...@gmail.com wrote: Format of B5:D5 is TEXT and B7:D7 is General. If Both rows will have same formats then you will get same answer visa vera. On Wednesday, December 24, 2014 2:50:56 PM UTC+3, amar takale wrote: -- Are

$$Excel-Macros$$ Re: small issue

2014-12-25 Thread Mandeep Baluja
It contains non printable characters try this method clean. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Wednesday, December 24, 2014 5:20:56 PM UTC+5:30, amar takale wrote: -- Are you

Re: $$Excel-Macros$$ Re: small issue

2014-12-25 Thread amar takale
thanks mandeep sir On Fri, Dec 26, 2014 at 11:32 AM, Mandeep Baluja rockerna...@gmail.com wrote: It contains non printable characters try this method clean. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939