Forum Discussion
2 decimal places - help please
Perfect, thank you. I had just discovered the answer when you replied although the other solution says use "##.##" instead of your zeros
Another variant is to keep resulting cell value as the number and apply to it custom number format as desired. That allows to use this number in other calculations without back transforming from text to number.
For example, you have 2250 as result of some calculations:
Click Ctrl+1 on the cell and apply custom format
"Subtotal "£#,##0.00; "Subtotal -"£#,##0.00;"Subtotal" £#,##0.00;First group separated by semicolon is for positive numbers, next to negative and when for zero.
Thank you Sergei, I didn't realise you could customise that far. If someone else opens my spreadsheet and does not have that customisation set up will it still display okay?
Yes, custom number format is available for everyone as any other format. The only difference you may apply format from menu (e.g. Currency, Number, etc.), when format code will be generated automatically. Or you may add it manually using Custom, in this case you have more options for formatting.
That's a lot of info about custom number formats with samples, first what Google returns is https://exceljet.net/custom-number-formats