The use of =

Question

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...&nbsp; How do I change that?

hansvogelaar · Answer

Wynandus&nbsp;
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.

wynandus · Answer

Thanks, but it does not resolve the problem. The cells are formatted standard and some cells show the result of the related cells and others do'nt. Can I write in Dutch?

wynandus · Answer

Thanks for your help. I discovered that putting a space after te = resolve the problem...

sergeibaklan · Answer

Wynandus&nbsp;
Perhaps you may share small sample file, it'll be more effective.

hansvogelaar · Answer

Wynandus&nbsp;
Wynandus&nbsp;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.

Forum Discussion

The use of =

5 Replies