Forum Discussion
What does the custom format "#,##0.00 _€" do?
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 g...
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