Creating a TEXT formula to link a word in one cell with a number v

G

Guest

Okay, so I have been searching all day for the answer to my question.

I am hoping one of you can help, using Excel 2003.

Created a TEXT formula, followed the sample one in the online help.

If I do an Evaluate Formula in the auditing feature the values are correct,
Excel is grabbing the right data. However in the cell I am trying to display
it, it is still showing the formula not the answer to the formula.

Any hints?

Thanks,
 

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

My & and TEXT formula is not calculating 2
Formula appearing as Value in Formula Bar 1
select all cell containing any formula and not text or number 2
Word Using the 'IF' Formula in MS Word 2010 0
setting cells with formulas 1
Excel Formula for Eclipsing Circles 0
Put Formula in VBA 1
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2

Top