Strange behavior in some of my formulas

[steveaust]

Hi guys, I have the strangest behavior in an Excel worksheet I have ever seen.
I have uploaded a small portion of my worksheet to my dropbox.
https://www.dropbox.com/s/ptm4ie27k3gl0pc/Strange.xlsx?dl=0

Strange behavior 1
The first formula calculates the age from a date of birth. Works fine, no issues with the formula.
So when I click B2 the formula is correctly displayed in the top display field. (i.e. to the right of the fx symbol)
But when I click in the top display field (to say make an edit of the formula) and simply hit enter, the formula is done, replaced by the number that was displayed!
I have no idea what is going on.


Strange behavior 1
In the next formula (in B7) the same behavior occurs as above, but instead of the numeral renaming, a "#N/A" is displayed.

I should say all other formula's on my worksheet do not have this "strange behavior" and do not vanish when doing an edit.
Anyone know what is going on?

 

[jmacleary]

After a quick look, I'm not sure why behaviour 1 is happening, but behaviour 2 is because the formula is an array formula and you will need to press ctrl-shift-enter to preserve it as an array formula.