show result no formel
 

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

show result no formel
 

Hi Mia,

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

--
Regards,

OssieMac


"Mia" wrote:

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

show result no formel
 

Hi,

I have tryed this, it don´t help.

//
Mia


"OssieMac" skrev:

Hi Mia,

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

--
Regards,

OssieMac


"Mia" wrote:

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

show result no formel
 

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.
--
Regards,

OssieMac


"OssieMac" wrote:

Hi Mia,

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

--
Regards,

OssieMac


"Mia" wrote:

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

show result no formel
 

Thank You!

I´ve got it to work!!!


Br
Mia


"OssieMac" skrev:

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.
--
Regards,

OssieMac


"OssieMac" wrote:

Hi Mia,

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

--
Regards,

OssieMac


"Mia" wrote:

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