$$Excel-Macros$$ Re: insert = in every cell as prefix with nos & Blank

2009-08-14 Thread Bakul Patel
HI Abdul, Is it possible to insert '=' as prefix with nos only.   If yes, give me code.   Thanks, Bakul  --- On Fri, 8/14/09, Abdul Shakeel wrote: From: Abdul Shakeel Subject: $$Excel-Macros$$ Re: insert = in every cell as prefix with nos & Blank To: excel-macros@googlegroups.com Date: Friday,

$$Excel-Macros$$ Re: how to make unique key

2009-07-25 Thread Bakul Patel
----- Original Message - From: Bakul Patel To: excel-macros@googlegroups.com Sent: Friday, July 24, 2009 7:57 AM Subject: $$Excel-Macros$$ Re: how to make unique key Hi Aamir,   Just a quick question. Do you maintain this spreadsheet for one year only & create new for next year? bec

$$Excel-Macros$$ Re: how to make unique key

2009-07-23 Thread Bakul Patel
Hi Andy,   Would you be able to make your file (for unique key) in .xls format? Cheers, Bakul --- On Thu, 7/23/09, Aindril De wrote: From: Aindril De Subject: $$Excel-Macros$$ Re: how to make unique key To: excel-macros@googlegroups.com Date: Thursday, July 23, 2009, 9:22 PM Dear Aamir,  

$$Excel-Macros$$ Re: how to make unique key

2009-07-23 Thread Bakul Patel
Hi Aamir,   Just a quick question. Do you maintain this spreadsheet for one year only & create new for next year? becasue in your second sheet i can't find date. Would you please explain me what exactly you want? what is SUFF & CURR?   Also Do you want closing balance on 30/06/XX only or monthly

$$Excel-Macros$$ Re:

2009-07-01 Thread Bakul Patel
Name: Bakul Patel Tip: Dictionary in excel   If you want to use dictionary in excel, just press ALT key & click on cell which has the word. you will get the meaning of the word.   Cheers, Bakul   --- On Tue, 6/30/09, Ramesh Katta wrote: From: Ramesh Katta Subject: $$Excel-Macros$$ Re:

$$Excel-Macros$$ Re: Excel Tip of Week # 26

2009-06-23 Thread Bakul Patel
give an example. that would be gr8.   --- On Tue, 6/23/09, Pavan Kumar VVN wrote: From: Pavan Kumar VVN Subject: $$Excel-Macros$$ Excel Tip of Week # 26 To: excel-macros@googlegroups.com Date: Tuesday, June 23, 2009, 12:46 AM Hi,   Here's my contribution   If you have N/A or any other

$$Excel-Macros$$ Re: Options

2009-06-20 Thread Bakul Patel
Name: Bakul Patel Tip: Use F8 key to select range of cells.(No use of shfit key/mouse to select range of cells)    If you want to DEFINE name of different cell ranges, do like this.   Example: I want to give different names to following ranges using DEFINE function. Range:A1:B20,  A1:X10,  A1:S30

$$Excel-Macros$$ Re: Options

2009-06-19 Thread Bakul Patel
Hi Friends,   Name: Bakul Patel   Tip of the week; Convert name from "bakul" to "Bakul". If you have a big list of names & you want to make it like this then this would be helpful.      A  B   Result 1 bak

$$Excel-Macros$$ Re: Fwd: Convert $900,000 to $900k in graph...done

2009-04-09 Thread Bakul Patel
Hi Prashant,   Go to FORMAT CELL>Custom> _($#,k   this will solve your problem...   Cheers, Bakul   --- On Thu, 4/9/09, Prashanth Banneni wrote: From: Prashanth Banneni Subject: $$Excel-Macros$$ Fwd: Convert $900,000 to $900k in graph To: excel-macros@googlegroups.com Date: Thursday, April

$$Excel-Macros$$ Re: amt in words in excel add-in

2009-04-02 Thread Bakul Patel
Can anyone please send this add-in file?   Thanks in advance, Bakul   --- On Wed, 4/1/09, PUNEET NASA wrote: From: PUNEET NASA Subject: $$Excel-Macros$$ Re: amt in words in excel add-in To: excel-macros@googlegroups.com Cc: "harsh shah" Date: Wednesday, April 1, 2009, 1:27 AM   CAN U SEND

$$Excel-Macros$$ how to create macro in excel which can speak the cell content...

2009-01-18 Thread Bakul Patel
G'day guys,   I am trying to get a macro in excel which can speak the cell content.   I tried SPEAK & SAYIT function but it is not working in my computer...I have got windows XP Prof. & also i lost SAYIT function from my function list. How to get it back?   Please share your ideas.   Thanks.