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

[Guest]

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?

 

[Ron Rosenfeld]

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