Cell Formatting changes after cell entry

[AlInVegas2]

I've run into a strange issue where, when typing a formula or numeric value into a cell, its formatting changes from Accounting to Text. This occurs after each entry and requires that I reformat the cell to the desired format everytime. The spreadsheet was originally derived from Quickbooks in the event this might be the source of the aggrevation. Any pointers would be greatly appreciated.

 

[DanteAmor]

Maybe it helps.
Excel, Options, Adavanced, check or uncheck Transition navigation keys

Also
Check or uncheck
Transition formula evaluation
Transition formula entry.

Test with each of the options

 

[AlInVegas2]

I tried checking all three transition boxes with no change in the result. Then I tried copy/past on a new spreadsheet and the new sheet failed in the same way. I then deleted all the conditional formatting and the problem went away. I attempted one by one to figure which created the issue.. Wont have time to test until tmw.

 

[DanteAmor]

I tried checking all three transition boxes with no change in the result. Then I tried copy/past on a new spreadsheet and the new sheet failed in the same way. I then deleted all the conditional formatting and the problem went away. I attempted one by one to figure which created the issue.. Wont have time to test until tmw.

Well, I did not know about the existence of conditional formatting. But it's good to know that you already solved it.