$$Excel-Macros$$ Re: small query

2012-12-17 Thread Prince
Hi rendils, Please apply this: * Option Explicit 'Main Function Function SpellNumber(ByVal MyNumber) Dim Dollars, Cents, Temp Dim DecimalPlace, Count ReDim Place(9) As String Place(2) = " Thousand " Place(3) = " Million " Place(4) = " Billion " Place(5) = " Trillion "

$$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Prince Dubey
Hi Shrini, You need not to do anything just follow below mentioned steps 1: right click on the cell having Zero in it. 2: Choose format cell 3:Select Custome In Category Section 4:Type *;;; (Three semicolons)* under Type Hading 5:Click Ok Thats It Ragards Prince . On Thursday, September 13, 201

$$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Prince Dubey
Hi Shrini. Please follow steps mentioned. 1: right click on the cell having zero in it. 2:Select format cells 3:Select Custom In category section 4:Type (*;;;*) three semicolons under type hading. Thats it. Regards Prince On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote: > >

$$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Prince Dubey
Hi Shrini, Do the following 1 : Right click on the cell 2: Select format cells 3: Select *Custom *under Category section 4: Type (*;;;*) Three Semi Colons under type heading and Click OK thats it. regards Prince On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote: > > Dear Al

Re: $$Excel-Macros$$ Re: Small Query

2012-09-13 Thread David Grugeon
You could use this custom format #,###.00;-#,###.00;;@ The first section, before the first semicolon, is the format for positive numbers; the second is negative numbers; the third is for not displaying zeros; and the fourth displays text as text. Regards David Grugeon On 13 September 2012 20:3

Re: $$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Prince Dubey
Oh Yes, Pravin thanks allot for notifying me about my error. On Thursday, 13 September 2012 15:36:59 UTC+5:30, Pravin Gunjal wrote: > > *Dear Prince : *If we enter any other value also instead of zero it show > blank. > > *Dear Shrini : **You may use this one : *Go to Excel Options (Alt+T+O) > -

Re: $$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Pravin Gunjal
That's what Noorain did. On Thu, Sep 13, 2012 at 3:50 PM, Soni.Rajender wrote: > Hi > > The same can also be done using conditional formatting. > > Regards > Rajender Soni > > On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote: > >> Dear All >> >> If i enter 0(zero) in any cell.it

$$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Soni.Rajender
Hi The same can also be done using conditional formatting. Regards Rajender Soni On Thursday, September 13, 2012 12:40:13 PM UTC+5:30, shrini wrote: > Dear All > > If i enter 0(zero) in any cell.it should show blank cell. > It should not show the zero. > lease let me know how to do it > Tha

Re: $$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Pravin Gunjal
*Dear Prince : *If we enter any other value also instead of zero it show blank. *Dear Shrini : **You may use this one : *Go to Excel Options (Alt+T+O) --> Click on Advanced --> Display options for this worksheets --> remove the tick mark from : Show a zero in cells that have zero value. Regards

$$Excel-Macros$$ Re: Small Query

2012-09-13 Thread Prince Dubey
Hi Shrini, Do the following 1 : Right click on the cell 2: Select format cells 3: Select Custom under Category section 4: Type (;;;) Three Semi Colons under type heading and Click OK thats it. On Thursday, 13 September 2012 12:40:13 UTC+5:30, shrini wrote: > > Dear All > > If i enter 0(zero