View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
leo leo is offline
external usenet poster
 
Posts: 74
Default Get "####" when use alpha char in a cell referenced by a formula

On a timesheet, if a person did not work they have to type in why. However
this results in a "####" in the 'Total Hours' cell that contains the formula.
If using alpha characters in a cell that is referenced by a formula, how can
you get the result to just be a blank cell, and not the "####"? Thank you!