EXACT doesn't fill in the result

D

DBinSD

I know this is probably the simplist thing, but I cannot figure it out. I
put in the EXACT function via the tool, enter my values for cell1 and cell2.
In the function box it shows TRUE or FALSE, but in the cells themselves only
the formula shows (=EXACT(A4,C4) - not TRUE or FALSE. I tried to do the copy
and paste value to show the result but that also doesn't work. It must be
something simple, but I'm just not seeing it.
Thank you - dbentley
 
E

Elkar

There are 2 likely reason why this is happening.

First, check to make sure that the Display Formula option is turned off.
1. Goto TOOLS Menu
2. Select OPTIONS
3. On the VIEW Tab, uncheck "Formulas"
4. Click OK

If that's not it, make sure the cell containing the formula is not formatted
as text.
1. Select the cell your formula is in
2. Goto the FORMAT Menu
3. Select CELLS
4. On the NUMBER Tab, select "General"
5. Click OK
6. Re-enter your formula

HTH,
Elkar
 
D

DBinSD

Thank you! The cause was that the cell was formatted as Text. But I
couldn't just reformat the cell - I had to reformat the cells and then
re-enter the formula.

Thank you very much for your help.
 
Top