Add value 0 to blank celss
 

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

Add value 0 to blank celss
 

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


"juan" wrote in message ...
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

Add value 0 to blank celss
 

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


"juan" wrote in message
...
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


.