The use of =

Copper Contributor

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?

5 Replies

@Wynandus 

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.

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?
Thanks for your help. I discovered that putting a space after te = resolve the problem...

@Wynandus 

Perhaps you may share small sample file, it'll be more effective.

@Wynandus 


@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.