Formulas sort is depending on the result of the formulas not
what the actual text is so yes excel by default sort by the value not
the name of the formula

--


Regards,


Peo Sjoblom

"Charess" wrote in message
...
Is it possible to sort the display value of the formulas. Our team is
building a database that will be updated frequently. However, since the
formulas need to be live it will not sort by the display value, just the
actual formula.

Any advice?

Thank you.

Charess