How about putting the formula  "=C3" in cell  D3?

Thank you. That's the first thing I tried, but for some reason or
other, it gave me an error flag, and the results did not sort as I
would have expected.

I found this page for you.

Probably this is what you want to do:

www.ozgrid.com/News/excel-evaluate-formula-VBA.htm

I'm only seeing one message at a time here; I'm used to seeing the
entire thread. I hope yours is the message I haven't replied to yet.
I want to make sure I thank everyone for their input.

Two of the replies, including yours, suggested something similar, and
although I haven't had a chance to try the suggestion, I'm pretty
confident that you have given me what I needed.

Try this:

A1= 21+69+89+25+31
A2= 21*25
A3= 100/10
A4= 100/10*(10*10+10)
A5= 100/10*10*10+10

without the "=" sign.

1) Select cell  B1
2) Go to Insert>Name>Define
3) Type the name Result (can be any valid range name)
4) In the Refers to: box type: =EVALUATE($A1)
5) Click Add then OK.

Very important to select cell B1 and use a Relative Row reference for
$A1.
6) Simply enter =Result into cell B1 and copy  it down.

I'll give it a try...................

First, Sorting the single column only sorts the formulas and with
relative references, the formulas always refer to the unsorted cells.
It might help if you told us what your ultimate goal for the values
is. THere may be a way to accomplish your final goal without a macro.

You clearly want the *value* in the cell  and not another formula,
right? Your PasteSpecial>Values is what you want, but any formula  you
put in a cell remains a formula and the result is normally shown.

I believe this is not possible (automatically) without VBA.
HOWEVER...
This is s simple macro. Simply turn on the Macro recorder
(Tools > Macro) and pick a name (no spaces, use _ ), then do the
PasteSpecial>Values thing on the cells or column you want, then stop
the Macro recorder.
To run it Tools > Macro > Macros Select your Macro name.

If you want to see the code go into the VB Editor ((Tools>Macro).
You can eventually assign this Macro to a button right on the sheet
that will run the macro.