format cell to view value not formula

S

SRSotherlund

Using Excel 97-SR1:
I have a cell that contains a formula. The formula works
fine but if I edit the existing formula to include an
ISBLANK() function, the cell displays the function rather
than the correct value. I have done this on several cells
and only have the display problem on cells that are
formatted as text. Cells formatted as number display the
correct value instead of the formula.

I have tried reformatting the cells. I even tried
clearing the format and then reestablishing. I have tried
turning on and off the Tools Option for display formula.
Nothing seems to work.

Please reply to (e-mail address removed)
 
B

Bernie Deitrick

SR,

Change the formatting, and then re-enter the formula. Cell formatting
is applied to the formula result, with the exception of Text, which
treats any entry as text.

HTH,
Bernie
MS Excel MVP
 

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

Copy addition formula of non-consecutive horizontal cells 2
Word macro that can call cells out of Excel for a find and replace 0
Show value from one cell in another cell if today falls between a date range 5
IF statement not returning correct answer 3
Show a cell's formula in text format in a linked cell 2
Drop down list control value in vba 2
Searching the formula (not the value) for a text string 1
countifs Function not giving desired result with date criteria 2

Top