How to Format and Display Large Numbers in Excel

preview_player
Показать описание
Watch this short, focused video to learn how to balance your need to maintain accurate and precise numbers in your data with your audience's need to see numbers that they can process, understand and act on.

The technique that I demonstrate is the Custom Number Format in Excel.


Sincerely,

Danny Rocks
The Company Rocks
Рекомендации по теме
Комментарии
Автор

Bad. I want to know how to display numbers with 30 digits or more and still add or multiply them like numbers (so no ' before to make it text--they need to act as numbers.

countyfacts
Автор

Thank U! This video helps me a lots :)

imphallyka
Автор

What do I use if I am trying to abbreviate in an address column East South North West to E S N W in a spreadsheet that is already done. What function would I use for that column?

BaitBend
Автор

Its easier to take off three "000" buy putting a comma, But how to strip off only TWO "00" ? finding it difficult to represent in Crore Kindly Reply

shrinivasjorapuri