See post in your other thread.

HTH

Giles

"Michelle" wrote:

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,