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
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)
> -
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
*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
