Formula... like text

  • Thread starter Thread starter Goharoth
  • Start date Start date
G

Goharoth

Hi to all, I have a really strange problem with an Excel file. This file is
linked with another to take some data, all the formulas works perfectly
but... one day, I don't know what I have done, two formulas are showed like
text (the formula is not parsed).

This is one of the formula:

=SE($A$16<>"";CERCA.VERT($A$16;[UNEETO.xls]RubricaClienti!$A$5:$R$41;15);"")

The formula is regular, if I copy & paste it to a new file work, so... why
in the original file doesn't work? O__O
 
Actually, you are correct! The cells have become text:

1. clear the cells
2. format the cells to General
3. re-enter the formulas
 
Back
Top