Yesterday I laughed at this, today Excel stripped leading zeros from a sheet of UPCs and converted them to floating point.

Also format as Text apparently means nothing