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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |