| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatonate and Substitute show the formula rather than the result
When I use the Concatonate wizard it shows the expected result in the wizard
dialogue box but when I press OK it just shows the formula in the cell rather than the result. I have tried formatting the target cell as General and Text and saved, closed and reopened the file but it doesn't help. I have the same problem with Substitute. What's going on? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatonate and Substitute show the formula rather than the result
After making sure that the target cell is formatted as General, re-enter
the formula. Does this help? In article , Pingu_3D wrote: When I use the Concatonate wizard it shows the expected result in the wizard dialogue box but when I press OK it just shows the formula in the cell rather than the result. I have tried formatting the target cell as General and Text and saved, closed and reopened the file but it doesn't help. I have the same problem with Substitute. What's going on? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatonate and Substitute show the formula rather than the re
Thanks Domenic, it works if you make sure the cell you are putting the
function in is formatted as General. "Domenic" wrote: After making sure that the target cell is formatted as General, re-enter the formula. Does this help? In article , Pingu_3D wrote: When I use the Concatonate wizard it shows the expected result in the wizard dialogue box but when I press OK it just shows the formula in the cell rather than the result. I have tried formatting the target cell as General and Text and saved, closed and reopened the file but it doesn't help. I have the same problem with Substitute. What's going on? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
