Everytime I sort, it sorts by the formula and I want it to sort by the value
of that specific formula. How can I get it to recognize my value as my
sorting option?

On Wed, 26 Oct 2005 13:30:06 -0700, Mar wrote:

Everytime I sort, it sorts by the formula and I want it to sort by the value
of that specific formula. How can I get it to recognize my value as my
sorting option?

It should do that unless you have entered the formula as TEXT.

If you are seeing "value" in the cell, it should be sorting by the "value".

If it does not appear to be doing that, post an example.


--ron