Custom cell format not applying

[lefthandedgoat]

I have found a custom format that is not applying correctly.

#,##0.0000 %

If I remove the space it works correctly, but the files I am processing are from a third party and I can not modify them.

I will also send an email with a excel sheet to reproduce.

Please let me know if there is anything else I can do to help. Thanks!

[snoopyjc]

The '%' character needs to be treated as any other escaped character in the format in that it appears unchanged in the output in the same place it appears in the format, and then the value is multiplied by 100 for each '%' found before being formatted.