Cell Formatting changes after cell entry

AlInVegas2

New Member
Joined
Jun 19, 2019
Messages
5
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

Well-known Member
Joined
Dec 3, 2018
Messages
8,932
Office Version
2007
Platform
Windows
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


 
Last edited:

AlInVegas2

New Member
Joined
Jun 19, 2019
Messages
5
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

Well-known Member
Joined
Dec 3, 2018
Messages
8,932
Office Version
2007
Platform
Windows
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.
 

Forum statistics

Threads
1,082,507
Messages
5,365,978
Members
400,863
Latest member
RobynP51

Some videos you may like

This Week's Hot Topics

Top