cell reference returns cell address instead of value

[DH613]

Hi,
I'm having an issue in one workbook only, that when I reference another cell, even on the same sheet, it shows the cell address instead of the value.
For example, if I wanted to add "Mr." to a a name in a2 I typed ="Mr. "&a2 and it returns ="Mr. "&a2 instead of the "Mr. text in a2"

 

[Alex Blakenburg]

Check that your cell formatting is not set to Text,

 

[DH613]

That worked!
Thank you

 

[Alex Blakenburg]

You're welcome. Glad I could help.