Can anyone explain me this formatting
Code: Select all
b:#,##0.00;(#,##0.00)♀CO|2|Y
Thank you!!
Code: Select all
b:#,##0.00;(#,##0.00)♀CO|2|Y
Oh I had no idea, Thank you!
Thank you, I'm gonna read Wim's page.gtonkin wrote: ↑Mon Oct 21, 2019 7:27 pm The closest I can find is this reference.
Basically the b: is for built in as far as I know and formats starting c: are custom.
The next bit is the mask i.e. show thousand separators as commas (or per your regional settings).
The bit after the non-ascii symbol probably relates to the above article i.e. Comma, 2 decimals (looks to be API and deprecated)
If you play around with the formatting, you will see the different codes based on your selection.
There may be "older" folk who have access to a developer/reference guide where this is explained better.
Also, look at Wim's page here.
It's a Form feed character (ascii code 12) apparently.