$$Excel-Macros$$ Daniel -- calendar pop-up

HI Daniel, Excel file with date function attached by you is really nice. How do I make it available to every excel file i.e. I want to use it in all workbook. Kindly guide me. Thanks in advance. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: e

$$Excel-Macros$$ Re: calendar pop-up

HI Dilip, I am not finding Calendar Control in object menu. How did you inserted that, kindly explain. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dilip Pandey

$$Excel-Macros$$ Re:

the format cells dialog on the Number tab click Custom in the category list; 3) In the type field type #,##0 "Kg." For detail see the attached file. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: excel-macros@googlegroups.com [ma

$$Excel-Macros$$ Re: How to protect range of cells

low user to delete the content in a cell. But it will not allow to edit the content of the cell. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Ramesh Katta Sent: 20 Ju

$$Excel-Macros$$ Re: how to extract text from a cell? urgent need !!!

Hi Nishant, Please explain the formula. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Nishant Jain Sent: 13 June, 2009 9:17 PM To: MS EXCEL AND VBA MACROS Sub

$$Excel-Macros$$ Re: how to extract text from a cell? urgent need !!!

Hi Ankur, Please find the solution in attached sheet. You need not use any formula. I did it only by using find & replace and then convert text to column. Thanks & Regards, CA Narendra Ashara | M.Com., A.C.A. | -Original Message- From: excel-macros@googlegroups.com [mailto:e

$$Excel-Macros$$ Display Your Numbers As Thousands

the dialog launcher arrow on the bottom right corner of the Number group. From the Number tab, click Custom, type 0, (zero comma) in the Type field and click OK. Thanks & Regards, CA Narendra Ashara | M.Com., A

$$Excel-Macros$$ Re: Doubt on data range

Dear Ramesh, You need to freeze the range by F4. Please find the solution in the attached sheet. Thanks & Regards, Narendra -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Ramesh Katta Sent: 07 June, 2009 5:25 PM To: excel-macros