View Single Post
  #2   Report Post  
Ray A
 
Posts: n/a
Default

one way
FormatCellsNumber
HTH

"brit64" wrote:

where my formulae may show negative results in my spreadsheet, in some
instances I want to display a zero (0.00) instead (with no minus - or
positive + preface symbols). Please help. Thanks in advance.