Thread: Unwanted dash
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Remo Shiva Remo Shiva is offline
external usenet poster
  
Posts: 3
Default Unwanted dash
Sandy Mann wrote:
I assume that your cells are formatted as Accounting and the dashes indicate
a zero. If so try:

=IF(SUM(your range)=0,"",Sum(your range))



thanks so much, works perfectly
Reply With QuoteReply With Quote