Custom Formatting In Excel, Numbers In Thousands And Millions
📽 11 Simple Formatting Tips To Increase The Professionalism Of Your Excel Spreadsheet
• Excel Spreadsheet Form...
📚 Content that influenced this video:
[Book] John Walkenbach & Michael Alexander, Excel Dashboards and Reports - amzn.to/3D6aqrI
[Article] Microsoft, Number format codes -
support.microsoft.com/en-us/o...
Пікірлер: 17
📽 11 Simple Formatting Tips To Increase The Professionalism Of Your Excel Spreadsheet kzread.info/dash/bejne/q4d-qMVpgMq9nKg.html
@iZacq
5 ай бұрын
I want it show like this 10,000 not 10,000.00 How to do that ? Please
Looks great. Very easy
@HowToAnalyst
Жыл бұрын
Glad to hear!
Now I no longer need to divide large numbers by 1,000 in order to format XD Thanks, HTA!
@HowToAnalyst
Жыл бұрын
This is much better Ben!
Can we make a custom format for the phone number so that the country call is in color and the number is supplemented with another Bonn..using the custom format Is that possible my friend ! ❤❤
How can I give superscript in it? Like if I wanted to write a unit of cubic meters ie. m3
Respected Sir nice video I have a query that how to format numbers in crores
Great Thks 👍, but what means the underscore in Excel formating ?
@HowToAnalyst
7 ай бұрын
Great question, it's a space!
how to dynamically switch from K, M, and B format using that custom format? is it possible?
@HowToAnalyst
10 ай бұрын
Great question, I’ll add it to my list!
how to do the same for very small number? like 0,0005?
@HowToAnalyst
8 ай бұрын
Good question, let me add it to my list
How to format in hundreds
@HowToAnalyst
8 ай бұрын
Good question, you have to do some division for that, adding to my video queue