show result no formel

M

Mia

Hi,

I have problem with a list that I have imported from share point. The formulas
that I make do not show the result.

Ex.
Cell d2 19872512-4525
Formel =EXTEXT(d2;2;6)
Result should be 872512

But the cell show the formel and not the result. Do any one know how to fix
this?
I have tryed Ctrl+', it don´t work.

I would be wery grateful if someone can help me.

BR
Mia
 
O

OssieMac

Hi Mia,

The column is possibly formatted as text. Re-format the column to General
using Number format.
 
O

OssieMac

Forgot to say that you might have to make a dummy edit on your formula to get
it to work after re-formatting. Simply select the cell and then delete and
re-enter a character in the formula.
 
Top