$$Excel-Macros$$ How to hide formula in cell......?

2013-02-24 Thread kumar.ashish861
Hi Group, I want to hide a formula in cell. then, what should i do for this. plz provide solution for the same. Thanks Ashish -- 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.

$$Excel-Macros$$ Re: Please Help

2013-01-10 Thread kumar.ashish861
Dear Karthik, your query is solvedpls check it. Thanks Ashish Kumar On Wednesday, January 9, 2013 8:07:11 PM UTC+5:30, karthik n wrote: > > Dear Help > > Please help for below attached file. > > > -- > > *Regards* > -- Join official Facebook page of this forum @ https://www.faceboo

Re: $$Excel-Macros$$ Need Help to seperate Date & time

2013-01-10 Thread kumar.ashish861
; understanding of your data structure. > > > On 10-01-2013 1:01 PM, kumar.ashish861 wrote: > > Dear Seniors, > > Pls help to seperate date & time, if both are in 1 cell. > >7/11/2012 13:51 > > Formula req..! > > Thanks in advance > > &g

Re: $$Excel-Macros$$ Need Help to seperate Date & time

2013-01-10 Thread kumar.ashish861
r time > =date(Hour(a1),minute(a1),second(a1) > and press ctrl+shift+@ > > On Thu, Jan 10, 2013 at 1:01 PM, kumar.ashish861 > > > wrote: > >> Dear Seniors, >> >> Pls help to seperate date & time, if both are in 1 cell. >> >>

$$Excel-Macros$$ Need Help to seperate Date & time

2013-01-09 Thread kumar.ashish861
Dear Seniors, Pls help to seperate date & time, if both are in 1 cell. 7/11/2012 13:51 Formula req..! Thanks in advance Ashish kumar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread kumar.ashish861
Dear Noorain, Congratulations Noorain! You are the shining star of this group.! keep it up. Cheers.! Thanks Ashish On Saturday, August 4, 2012 10:00:11 PM UTC-7, Andy wrote: > > Great Work Noorain!! > Though I have been silent in this group for quite some tim

Re: $$Excel-Macros$$ How to calculate Days and Time.

2012-07-31 Thread kumar.ashish861
u can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* kumar.ashish861 > *To:* excel-macros@googlegroups.com > *Sent:* Mon, July 30, 2012 1:40:26 PM > *Subject:* $$Excel-Macros$$ How to ca

$$Excel-Macros$$ How to calculate Days and Time.

2012-07-30 Thread kumar.ashish861
Hi Champs, Please help regarding how to implement Time Consumed formula. Thanks in Advance. Courier Dispatch from Delhi Courier Received in USA Time Consumed Time / Date Time /Date

$$Excel-Macros$$ Re: Multiple Versions of Excel

2012-07-30 Thread kumar.ashish861
Dear Ashish Pradhan, Don't use two versions of Excel in one Machine. If you, install two versions of excel in your machine, your PC is not working properly. 2010 version is better option & it is easy to use & If you want to replace your excel version, there is no "Version Clash issues" and you

$$Excel-Macros$$ Re: Cursor Drag Option in Excel

2012-07-25 Thread kumar.ashish861
Dear Balbir, First u have to select a cell & copy it (what you want to paste), then select a range, including the copied cell (where u want to paste the data) the press CTRL + D Thanks Ashish On Wednesday, July 25, 2012 5:45:10 PM UTC+5:30, Balbir Kumar wrote: > > Dear Friends, > > > I am n

$$Excel-Macros$$ How To Create DynamicChart

2012-07-20 Thread kumar.ashish861
Dear Champs, kindly help me to create Dynamic Chart & give some knowledge about the tools and functions, define the tool names and how to use these tools & functions to create dynamic charts. Thanks in advance..! Thanks & Regards Ashish Kumar -- -- FORUM RULES (986+ members alrea

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-17 Thread kumar.ashish861
> -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861 < > kumar.ashish...@gmail.com> wrote: > >> Dear All, >> >> Kindly help me to convert numbers

Re: $$Excel-Macros$$ How to Convert words in digits.

2012-07-17 Thread kumar.ashish861
Chacko > > On Mon, Jul 16, 2012 at 11:15 PM, kumar.ashish861 < > kumar.ashish...@gmail.com> wrote: > >> Dear All, >> >> Kindly help me to convert numbers in digits. I'll apply the formula >> "spellnums" but, I think this formula is working only

$$Excel-Macros$$ Re: How to Convert words in digits.

2012-07-17 Thread kumar.ashish861
Dear Guys...! Thanks a lot. On Monday, July 16, 2012 11:15:55 PM UTC+5:30, kumar.ashish861 wrote: > > Dear All, > > Kindly help me to convert numbers in digits. I'll apply the formula > "spellnums" but, I think this formula is working only in Office 2003. &g

$$Excel-Macros$$ Re: Introduce Yourself !!

2012-07-15 Thread kumar.ashish861
Hi All, Iam Ashish from Delhi, I love excel and loves to learn new tweeks and tricks. Thish Forum is ROCKS..! On Saturday, June 9, 2012 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of exce