Excel only displays the formula
Solved
Yan_de_ruelle
Posted messages
27
Registration date
Status
Member
Last intervention
-
AG -
AG -
Hello,
Configuration: Windows XP / Internet Explorer 6.0
After many searches on the internet and the forum, I can't find a solution to my problem.
The original Excel file does not come from my PC.
Originally, I wanted to use the CONCATENATE function to recreate lists of first names.LAST NAMES That’s where the trouble starts. Excel displays the formula and not the result. I’ve tried everything, changing the cell format, F9, using =&A1;&A2
Nothing works in this file. Even when changing the cells to Number format and inserting numbers into the cells, nothing works. Excel only displays the formula. I should note that automatic formula calculation is enabled
However, when I tried opening a new document, it worked.
Does anyone have an idea where to look? Change a setting?
Configuration: Windows XP / Internet Explorer 6.0
After many searches on the internet and the forum, I can't find a solution to my problem.
The original Excel file does not come from my PC.
Originally, I wanted to use the CONCATENATE function to recreate lists of first names.LAST NAMES That’s where the trouble starts. Excel displays the formula and not the result. I’ve tried everything, changing the cell format, F9, using =&A1;&A2
Nothing works in this file. Even when changing the cells to Number format and inserting numbers into the cells, nothing works. Excel only displays the formula. I should note that automatic formula calculation is enabled
However, when I tried opening a new document, it worked.
Does anyone have an idea where to look? Change a setting?
