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: 11 Responses to “10 Useful Numbers Cell Formatting Examples”

    John Russell
    3 years 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
    3 years 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?

    3 years 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
    3 years 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).

    3 years ago

    Eric: In American English is it "meter."

    Jean-Claude
    3 years ago

    Thanks Gary!

    Margaret Smith
    3 years 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.

    3 years 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
    3 years ago

    Thanks Gary. All fixed.

    Peter
    3 years ago

    Hello Gary, can I add text to a cell which has the result of a calculation? For example, if I'm calculating a sum of prices. I'd like the cell to show the result $230 for example, but I'd like text after the amount, so $230 sales for example. Is this possible?

    3 years ago

    Peter: Yes. You can do that with a custom format. See around 11:20.

Comments Closed.