Hello David,
You can use Format Cell action from MS Excel VBO and update cell format to Custom format.

Then perform a save action on excel and then try to Get the Worksheet as a collection.

This should resolve your issue.
Try and let us know how it goes.
------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------