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
    1 year 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
    1 year 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?

    1 year 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
    1 year 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).

    1 year ago

    Eric: In American English is it "meter."

    Jean-Claude
    1 year ago

    Thanks Gary!

    Margaret Smith
    1 year 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.

    1 year 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
    1 year ago

    Thanks Gary. All fixed.

    Peter
    12 months 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?

    12 months ago

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

Comments Closed.