Forum Discussion
Merge text with "&" results in strikethrough
As of today I noticed the Excel Function: ="text "&A2, where A2="Nr" returns in a strikethrough text. In the Tab Font the strikethrough button isn't checked. What's wrong?
You probably set the sheet to manual calculation mode with 'stale value formatting' enabled. That results in the strike-through effect as soon as you enter something in the sheet.