View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
juan juan is offline
external usenet poster
 
Posts: 29
Default 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