View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mtabaruka Mtabaruka is offline
external usenet poster
 
Posts: 6
Default Removing Placeholder Values

I dont want to show place holder values that show were there are formulas but
the cells referenced by the formulas dont have values as yet. e.g cell G34
has formula: =SUM(F24:F33) and the referenced range has no values but G34
shows 0.00. The number format of G34 is NUMBER with a 1000 SEPARATOR to 2
DECIMAL PLACES.
--
Wether you think you can or you think you cant , you are right ... anon