Negative numbers

  • Thread starter Thread starter Roger R
  • Start date Start date
R

Roger R

Is there a formula that would make negative numbers into
zero? I've tried customer formating (0.00;"0";0.00) which
didn't work for me. The negative numbers that I want to
change are imported, and they come in with the negative
sign after the number (54-). Any help would be greatly
appreciated.
Roger
 
you might try this macro
for each c in selection
if right(c,1)="-" then c.value=0
next
 
If you're just interested in the display, you can use (since 54- is
imported as Text):

0.00;"0";0;"0"
 
Back
Top