show result no formel

  • Thread starter Thread starter Mia
  • Start date Start date
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
 
Hi Mia,

The column is possibly formatted as text. Re-format the column to General
using Number format.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching in excel 2
Automatic macro 5
String of numbers 6
Find row 1
add new value with previous in same cell 2
Printing with functions (staples) 2
Problem with formula 1
macro to calculate or make/update formula 1

Back
Top