Display numbers in millions in Excel

preview_player
Показать описание
00:00 Fitting more numbers onto a dashboard page
00:19 Reporting in thousands/ millions/ billions in Excel
00:28 Custom formatting Excel numbers into millions
01:12 Custom format millions- spaces versus commas on different machines
01:34 Display number in thousands
01:48 Display number in millions
01:55 NB- The number is displayed in millions BUT Excel still sees full number
02:33 Add decimals to the millions format
03:07 Spaced saved on a dashboard report using numbers in millions

How to save space on an Excel dashboard by formatting the full numbers into thousands, millions or billions. Also how to include some decimals to these million formats.
Рекомендации по теме
Комментарии
Автор

Hi…. I need to convert my figures in thousands. The conditional formatting does that. However, the resulting thousands figures don’t have comma separators. I need commas in my resulting thousands figures. Could you please help!

nehanagpal