I've put a formula in a field, the result won't show

K

kanye

I've inputed a formula that generates a result when I do Insert Function and
enter the argument; however, the result is not reflected in the cell. I've
tried to cut and paste the formula as a Paste Special, Values only but that
doesn't work. Please advise.
 
G

Guest

Hi

You say the result is not reflected in the cell. What is in the cell, then?
If it's a wrong result, check Tools|Options|Calculation is set to Automatic.
If it's the formula itself try Tools|Options|View and uncheck Formulas.
Otherwise post back!

Andy.
 
K

kanye

The cell shows the formula itself. The formula is correct b/c I see the
result when I do Insert, Function, and insert my arguments.
 
G

Guest

OK. Have you checked the two items I mentioned in my previous post? What is
the function you are using and what are the arguments? When you have entered
the arguments using the Insert Function option, what does the dialog box
show the result to be (in the bottom right-hand corner)?

Andy
 
K

kanye

Thanks Andy, I figured it out. The formula was reading data from fields
saved as text instead of numbers. Once I converted the text to numbers, the
result showed in the cell.
 
G

Guest

Glad to hear you got sorted!

Andy.

kanye said:
Thanks Andy, I figured it out. The formula was reading data from fields
saved as text instead of numbers. Once I converted the text to numbers,
the
result showed in the cell.
Click to expand...
 
Top