I just "upgraded" to office 2016 and i was attempting to do some basic spreadsheet stuff. In previous versions if you had 56 in cell A1 and jumped into a text string formula =$a$1&"is a number" the result would be 56 is a number. Office 2016 is forcing me to use the text function. Is there a setting somewhere to resolve this? Can Excel no longer figure out what string =value(56) should look like?

Grrr,

Please advise,