10 Useful Numbers Cell Formatting Examples

Often the solution to a problem in Numbers isn't to use a formula, but to use custom cell formatting. See some practical examples such as adding units, abbreviating large numbers, replacing 0 values with blanks, showing hexadecimal numbers and much more.

Comments: 9 Responses to “10 Useful Numbers Cell Formatting Examples”

    John Russell
    2 months ago

    This was a super helpful video. As is often the case, I now desperately need to search my life for cool uses for the information. Keep’em coming!

    Bart Pulverman
    2 months ago

    I recently migrated from Excel and Word to Numbers and Pages and this video explained several functions that make the transition easier.

    Do you have any videos that are specifically designed for people who are comfortable in Excel and Word, but need to learn how to work with their old documents once they are imported into Numbers and Pages?

    2 months ago

    Bart: I don’t have anything that specifically deals with that. I would imagine what you need greatly depends on the types of documents you have and your experience with each app. Just explore and experiment with test documents to figure things out.

    Eric
    2 months ago

    I noticed in some comments that people had pointed out the use of “to” vs “too”. In a similar vein, and again not to detract from the really useful content of the video, I’m pretty sure that the measure of distance is “metre” and not “meter” (even in American English).

    2 months ago

    Eric: In American English is it “meter.”

    Jean-Claude
    2 months ago

    Thanks Gary!

    Margaret Smith
    2 months ago

    I am trying to enter a column with postcodes. In our area they begin with a zero e.g.0920 My cells will not accept the zero and covert to 920. Help please.

    2 months ago

    Margaret: Either set the format of the cells to “Text” before entering in the data, or set a custom format for 4 digits, no separator, with “Show Zeros For Unused Digits.”

    Margaret Smith
    2 months ago

    Thanks Gary. All fixed.

Leave a New Comment Related to "10 Useful Numbers Cell Formatting Examples"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)