Show numbers in millions, red for negative and - for zero in Excel

preview_player
Показать описание
00:00 Show Excel dashboard numbers in millions, red for negative numbers
00:44 See the sample in the custom format code
00:58 Add millions custom format with _
01:25 Positive numbers in millions, negative numbers still full number
01:36 Convert negative numbers into millions
01:50 Add decimals to your millions custom format
02:00 Make zeros appear as - in custom format

How to format your Excel dashboard numbers so that they appear in millions with decimals, negative numbers are red and zeros are shown as a dash - .
Рекомендации по теме
Комментарии
Автор

How do I change this such that negative is red with brackets instead of blank please? Thank you
0.000, , ;-0.0;-;@

powercarolmelb