I have a new "feature" that showed up this week. If I type a formula
referencing cells that have a specific format the format of the formula cell
changes to match.

for example column A has been formated as text. if I type the formaula =A2 &
A3 into B2 (still with the default General format) when I press enter the
format changes to text for B2. the result is correct untill I edit B2 at
which time the result changes to be "=A2 & A3". this only occurs if all of
the source cells have the same format and you are only referencing cells. =A2
& " " & A3 does not change the format of the formula cell.