Concatenate returns odd result
I have a problem with a simple table and a concatenate function, that sometimes returns a number instead of the text I expect. I suspect this is to do with forbidden characters, but I need help.
Each record is of a historical person: first name, last name, year of birth and year of death. All fields are text. The concatenate function (also set to text!) is:
First Name & " " & Last Name & " (" & Year of Birth ) & " - " & Year of Death & ")"
and so, with the fields populated (by composers), I get something like this:
Dieterich Buxtehude (1637 - 1707) (first screenshot)
However, Buxtehude might have been born in 1639
If I enter "1637/39" in the Year of Birth field, or "1637 or 39", then the concatenate field returns "1.6374e+09". (second and third screenshots). I'm guessing this is a number, (although the fields are all set to text). I've tried Quote and GetText, within Concatenate, to force the function to return strings of text, but to no avail.
When I click into the concatenate field, I get shown the text result I expect (fourth screenshot).
I am running FMP 12.0v5 on OSX 10.9.4