Defaulting empty Cell to 0

[Matt]

Unfortunately my brain has stopped functioning, is there a format or any other way to default an empty cell to show 0

thanks

Matt

 

[eliW]

On 2002-04-18 04:00, Matt wrote:
Unfortunately my brain has stopped functioning, is there a format or any other way to default an empty cell to show 0

thanks

Matt

Matt,
I assume that you want this for defined range of cells and not for all empty cells in the worksheet.
You can select all empty cells in a range by Edit | Goto | special | blanks, and put "=0" in the active cell.
Eli

 

[Matt]

Thanks Eli, is there a way of updating all cells in one hit or do I have to update individually?

thanks

Matt

 

[Adcb]

On 2002-04-18 06:20, Matt wrote:
Thanks Eli, is there a way of updating all cells in one hit or do I have to update individually?

thanks

Matt

Ctrl+Enter

 

[Matt]

Magic, cheers!