Excel Tip: Dynamic Number format for Millions and Thousands

Показать описание

#ExcelTip #NumberFormat
Hello Friends,
In this video, you will learn how to change the number format on a chart as millions and you will also learn how to change the number format on a table dynamically in thousand and millions. Whenever number will be in thousand it will display “K” and for million it will display “M”.
Click here to download the practice file:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

Рекомендации по теме

Комментарии

good job
it's very useful information
thanks mr pk

khaledsaleh

Thank you, you made some difficulties easy

مقدادحديد

Thank you for your video. This helps me a lot ! BR

ktkrzysztof

Nice one. I needed a refresher on the conditional syntax of the Custom number Format. For me I use:
"M";[>=10000]0.00, "k";#, ##0.0

Works like a case switch from left to right and returns the first criteria it meets.
Edit: This is gsheet and you can further tailor the decimal place to your liking with 'decrease' or 'increase decimal places' buttons.

norunaround