How can I sort by the value of my formula and not actual formula
 

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?

How can I sort by the value of my formula and not actual formula
 

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