| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Oversettelse av Engelsk formel | Excel Worksheet Functions | |||
| Creating a formel in excel | Excel Worksheet Functions | |||
| {} in formel | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| minus formel/fortegn | Excel Discussion (Misc queries) | |||
Hybrid Mode
