|re: It needs to be in this format to upload into our accounting system.|
I'm not quite sure how to word this response so it makes sense but I'll try...
You say it has to be formatted as Custom 000, 0000 or 00000 in order to be uploaded to your accounting system, yet you have never been able to actually format that data like that since the format doesn't hold. Do you see my confusion?
Who says it has to formatted as Custom 000, 0000 or 00000, since apparently this format doesn't actually exist?
What is something formatted as Custom 000, 0000 or 00000 supposed to look like?
When the format changes to one of the Specials, does the data look different than when first formatted as Custom 000, 0000 or 00000?
Perhaps if you provide some examples of input (pre-formatted) data and output (post-formatted) data that might help.