Negative numbers can be displayed in red and or with a negative sign. You can define the number of decimal places.Īllows you to use a comma seperator between groups of three digits (handy when working with large numbers). This number format is like the General format but with three differences:
How it is different to the General format Negative Numbers - The default is to display negative numbers with a minus sign, although there are the options to make negative numbers red, or display them in red with a negative sign. Use 1000 separator - The 1000 separator will insert a comma every 3 digits, i.e.
The default is 2 decimal places and negative numbers are displayed in black preceded by a minus sign.ĭecimal places - The number of decimal places can be from 0 to 30 and this can be changed by either typing directly into the box or using the spinner button. This gives you control over the number of decimal places displayed as well as the option of displaying basic punctuation, comma's and parentheses.
