Making negative numbers zero

  • Thread starter Thread starter Roger R
  • Start date Start date
Frank,
should this format be an option in my custom format list,
because I'm not finding it. I've tried to manipulate an
exsisting format that is close to what you have given me,
but it brings up a message that "no more customer number
formats can be added"

thx
 
Hi
you have to enter this format manually in the textbox above the list
with the existing custom formats
 
Frank,
I've gone back to this and finally made it work, I had to
format a blank sheet, then drop the numbers in, the
problem is that it didn't work. It made all of the whole
numbers into zero, and left the negative numbers as
negative. Is there a formula that I could use? One other
thing the negative numbers are imported in with the
negative sign after the number (4-), which might not make
a difference but I thought you should know.
 
Back
Top