dallen8028
New Member
- Joined
- Jan 28, 2013
- Messages
- 48
Some how, I don't know how; but I can no longer just enter numbers without the decimal point automatically placing itself at position 2. If I type 150 without the decimal point because I want it to be 150 it returns 1.50 . Something got changed, don't know what it was. It does not matter what I format it as, General, Number, Accounting or Currency, they all do the same. The only way I can get around this is by formatting as text.
Also, when I type a one or two digit number, ie: 1 or 18 it returns 0. This started happening in the middle of a session. I walked away with Excel was still open, the PC went to sleep, When I logged back in is when it all started.
Using Excel 2019 Standard.
PLEASE ADVISE! THANKS.....
Also, when I type a one or two digit number, ie: 1 or 18 it returns 0. This started happening in the middle of a session. I walked away with Excel was still open, the PC went to sleep, When I logged back in is when it all started.
Using Excel 2019 Standard.
PLEASE ADVISE! THANKS.....