That <Edit <Clear <Formats
is a new one on me!<bg
--
Regards,
RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------
"Myrna Larson" wrote in message
...
If they are formulas, you can do it a bit easier, I think:
To change the format: Edit/Clear/Formats
Then
Edit/Replace
Find What equal sign
Replace With equal sign
On Thu, 4 Nov 2004 15:02:22 -0800, "RagDyer" wrote:
*Just* changing the format will *not* solve the problem!
*After* the format is changed, then the formula must be re-entered.
This *does not* mean that you must re-type the formula.
Select the cell, hit <F2, then <Enter, and the formula will then
calculate.
If you have a few cells, you can change the format and re-enter the formula
with these keystrokes:
Select all the "bad" cells, then:
<Ctrl <Shift <~ once (shortcut to format to "General"),
Then <F2 <Enter for each cell selected.
|