May 28 2020 05:31 PM
I'm extracting data from an excel spreadsheet. The style.xml file has this format code in it:
<numFmt numFmtId="165" formatCode="#,##0.00\ _€"/>
The software I'm using, a Perl module, is getting confused by this format. I'd like to patch the module but I'm unsure on what this format is expected to produce. An underline is supposed to create a blank space with the same width has a euro character but that doesn't make much sense in this context. Similarly, there is this format code in the same file:
<numFmt numFmtId="166" formatCode=""$"* #,##0.00\ _€"/>
This is also confused me because the dollar sign in already in the format.
May 29 2020 11:00 AM
Custom number format in Excel has for parts (not all are required) separated by semicolons
positive;negative;zero;text
That's in your second case. Underscore means adds space on the right on the width of character after it. You may compare here
first and second are with same format, but in first case is euro sign after underscore, in second case i character. No customer format is applied to third number.
Not sure what quote shall mean in second case, but $ is not necessary currency, it could be in locale string as
More is here