Jul 18 2022 08:01 AM
Normally I use the = sign to relate to an other cell in another workmap. But now, when i do so, it does not show the result but the text to what cell it relates... How do I change that?
Jul 18 2022 08:10 AM
Make sure that the cell into which you enter the formula is NOT formatted as Text.
Also make sure that the Show Formulas button on the Formulas tab of the ribbon is NOT highlighted.
Jul 18 2022 08:21 AM
Jul 18 2022 08:29 AM
Jul 18 2022 08:29 AM
Perhaps you may share small sample file, it'll be more effective.
Jul 18 2022 09:11 AM
@Wynandus wrote:
Thanks for your help. I discovered that putting a space after te = resolve the problem...
That's weird, it shouldn't be necessary.
As Sergei asked: Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.