This fixed it for me. I tried several other formatting choices that didn't work. For some reason it reverts back to the original number form even after saving. ...

I understand - however, widening the cell does not change it back to its original form. thanks for you assistance!

I’m slightly familiar with excel automatically converting long numbers to formula when cell width is too short, but after widening the cell width with a click a...