![]() ![]() These newbie mistakes are uncalled for because Excel placed several number formatting options front and center in the Number section of the Home tab:įor the neophytes, here are what those icons mean, from left to right:Ĭonvert to currency. This option will left-align the dollar symbol and right-align the number. ![]() (If you want the currency symbol to be flushed up against the number, don’t use this icon use the Currency option in the drop-down menu above this row of icons.) Technically, this is referred to as Accounting formatting. You can also choose different currencies from the drop-down menu to the right of the currency icon. This is not a comma it’s a thousandths separator. And if you have a number greater than 9999 you should use it. (I usually use it for numbers greater than 999.) One weird quirk with this button is it adds two decimal places whenever you apply it. If you don’t have decimals, you should ditch the decimals because they just add noise. But that’s what the next icons are for.Īdd decimals. Since I’m not neurotic or a scientist, I very rarely use this option. PSA: Please - for the love of all that is holy and measurable - get rid of decimals in chart axes. #PUT NEGATIVE NUMBERS IN RED IN EXCEL FOR MAC HOW TO#.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |