I understand that you want the #Div0 to go away or behave differently, and I
am trying to help you with it. But I can't do that unless you give me the
information I ask for.

The #Div0 is shown in a formula cell. What is the formula ?

Best wishes Harald

"HERNAN" skrev i melding
...
Is a payment sheet so all the time I'm going to have ceros on the
accounts.
But I only need to sort the ones that have numbers on it, when I try to do
it. sorts the #DIV!0 first, and I don't want that.

"Harald Staff" wrote:

1500 formulas is easy to replace if they are equal. How many /different/
formulas do you have that returns Div0 ?
I believe you should get rid of the error, not the error message.

Best wishes Harald

"HERNAN" skrev i melding
...
Thank you, but There is any other way because I have more than 1500
formulas,
and I don't want to go each by each one.
Something like formating or view
O brigado


"Marcelo" wrote:

Hi herman,

use in an if function in your cell eg.
=if(iserror(a1/a2),0,(a1;a2))

change a1 a2 per your original formulas

hth
regards from Brazil
Marcelo

"HERNAN" escreveu:

I had a formula in a cell, that when ocurred I want it to hide, it
says
#DIV0! and when I try to sort that column it mess everything that
message.
I would like for example to say 0 instead of that error message,
but I
don't
know how to do it.
I would appriciate any help.
Thank you