My & and TEXT formula is not calculating

G

Guest

I created a formula to link text from one cell and a value from another cell.
I used the help and did exactly the same type of formula.

=G8&TEXT(O30, "0")

Now if I use the Formula Auditing -> Evaluate formula the expected result is
correct however in the excel cell it is not calculating and just displaying
the formula.

Please can anyone help?

Thanks
 
G

Guest

Sounds like you've got display formula's turned on.

Go to Tools, Options, View

and make sure there isn't a tick next to Formulas under Window options

HTH
Giles
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
formulas not auto calculating and will not calculate 8
conditional format fails when copied 1
Formula appearing as Value in Formula Bar 1
Keep Excel Formula constant 3
Creating a formula in VBA with quoted strings 1
Creating a TEXT formula to link a word in one cell with a number v 1
Excel Need Countifs Formula Help 0

Top