Excel Tip: Dynamic Number format for Millions and Thousands

[@adnanozkara3576]

Excellent

[@PKAnExcelExpert]

Thanks

[@norunaround1624]

Nice one. I needed a refresher on the conditional syntax of the Custom number Format. For me I use: [>=1000000]0.00,, "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.

[@pandharinathjoshi6565]

Ultimate sir

[@PKAnExcelExpert]

Thanks🙏

[@hazemali382]

Many Thanks Mr.PK

[@مقدادحديد]

Thank you ,you made some difficulties easy

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@khaledsaleh8604]

good job it's very useful information thanks mr pk

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Luciano_mp]

Awesome, beautiful chart, thanks.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@lcg_wormtrader83]

PK sempre com uma solução simples e eficiente. Parabéns !

[@ktkrzysztof2387]

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

[@PKAnExcelExpert]

Glad it helped!

[@medkari]

Merci Beaucoup

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@AriWibowo-qj2cx]

Many Thank You

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sunilkumar-jl7uf]

very informative

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@PratapSinghSoam]

Thank you sir

[@PKAnExcelExpert]

Thanks for watching

[@yulinliu850]

Much appreciated!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@tonyhallett3255]

Very cool, PK.

[@vijayjayarajan2528]

How to have the dynamic function for negative value as well

[@pawansharma-wo3xh]

Hi pk Please also make tutorial on newly launched function dynamic array excel.

[@PKAnExcelExpert]

Sure I will definitely try to make such video very soon.

[@ravir8773]

Hi pk, can we do the same with currency format

[@PKAnExcelExpert]

Yes you can do it

[@ravir8773]

@@PKAnExcelExpert could you please help me how do we do it along with currency format

[@Fabretteable]

Yes master!!! 😁

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Very very interesting and informative....awesome sir 👏👏👏👏👏

[@nageshshukla16]

Instead of Alt+O+E you can use Ctrl+1.

[@DM-YouTube]

How to show L for Lakh & Cr for Crore ?

[@satishburli2727]

How to contact you in Telegram sir

[@abdulshaikh8166]

pls send file

[@PKAnExcelExpert]

File download link has been given in videos discretion box. Please download this excel file from there