Add value 0 to blank celss

[juan]

Hello,
is there a way to fill empty blank cells with the value 0?
My sheets contain data for Period 1-12, for product group,
or customer but not all will have totals. Example,
product YTD Total PER1 PER2 PER3
IC 2 2
DUCTS 10445 992 1081 1225

So would like to have in Per1 and Per2 O instead of blank.

Hope I'm clear. Would appreciate any info.

Thank you,

Juan

 

[Ron de Bruin]

Hi Juan

Select the range
F5 > Special
Select Blanks
Enter a 0
And Use Ctrl-Enter instead of Enter

 

[JUAN]

Ron,
thanks for the info.

Juan

-----Original Message-----
Hi Juan

Select the range
F5 > Special
Select Blanks
Enter a 0
And Use Ctrl-Enter instead of Enter


--
Regards Ron de Bruin
http://www.rondebruin.nl





.