MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula Display

Posted by John M. Blanchard on October 23, 2001 11:42 AM

When I enter a simple concatenation formula w/ an "=" sign, only the formula displays, not the results. I have tried recopying the data to another workbook. I have also checked the Tools|Option|View tab to make sure the "Formula" checkbox is "unchecked". Any suggestions? Thanks

Posted by Mark W. on October 23, 2001 11:45 AM

Change the cell format to "General" and re-enter
the formula.