Unfortunately, the document is used to upload information into another system that is expecting a specific layout and values formatting. I have had it puke on formulas trying to do the display column bit. I am told by the admins that 1.01 is not going to work.

Seriously, in this world of tech having IP addresses, software versions, and all other kinds of reasons to use this format and have it sort properly, I can't imagine why Excel is so hard to deal with in this regard. Isn't there some way to build a mask to accomplish this? Some of my documents contain over 100 rows and manually updating each row is beyond inefficient.