First, hold down <Ctrl>, and hit the key with the <~> on it a couple of
times.
If that doesn't correct the problem, click in the "bad" cell containing the
formula, and then:
<Ctrl> <Shift> <~>
Then hit <F2>
Then hit <Enter>.
The first procedure changes the WS from Normal view to Formula view and then
back again.
The second procedure re-formats the cell to General, then re-enters the
formula,
meaning that the cell was formatted as Text before you entered the formula
the first time.
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.
