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?
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?
![J2ZKaw0.png](/board/proxy.php?image=http%3A%2F%2Fi.imgur.com%2FJ2ZKaw0.png&hash=92b183841f4da889317a8d2121a052e8)