Newto
Level 1 (0 points)

Q: How can I customize a number format?

In the previous numbers release (Numbers 9) there was a menu were you were able to customize a number format similar to what you can do with Excel. Have they drop this functionality in the new release?

MacBook Pro, Mac OS X (10.7.4)

Posted on Nov 7, 2013 4:38 PM

by Barry,Solvedanswer
Barry Barry
Level 7 (32,714 points)
iWork
A:

See this thread for a comprehensive list of missing features. The most current version of the list, as of this posting, is on page 14. The link should take you to that page.

 

Regards,

Barry

Posted on Nov 7, 2013 5:27 PM

Close
Newto

Q: How can I customize a number format?

  • All replies
  • Helpful answers

  • by Barry,Solvedanswer

    Barry Barry Nov 7, 2013 5:27 PM in response to Newto
    Level 7 (32,714 points)
    iWork
    Nov 7, 2013 5:27 PM in response to Newto

    See this thread for a comprehensive list of missing features. The most current version of the list, as of this posting, is on page 14. The link should take you to that page.

     

    Regards,

    Barry

  • by SGIII,Helpful

    SGIII SGIII Nov 7, 2013 7:13 PM in response to Newto
    Level 6 (10,796 points)
    Mac OS X
    Nov 7, 2013 7:13 PM in response to Newto

    And, in case you would like to get a more balanced view about new features as well as those removed, there is this article  and this thread.  Plus this announcement from Apple about features they plan to restore in releases over the next six months.

     

    If you use Excel and have a particular customized number format you need to use, I understand you can open the spreadsheet in Numbers and that customized format will be imported and made available to you in Numbers 3.0.

     

    SG

  • by Yellowbox,Helpful

    Yellowbox Yellowbox Nov 7, 2013 10:08 PM in response to Newto
    Level 6 (10,550 points)
    Mac OS X
    Nov 7, 2013 10:08 PM in response to Newto

    Hi Newto,

     

    Adding to SG's suggestion to create a customised cell format in Excel. You can use Numbers 2 to creat a custom format. Save the document and then open it with Numbers 3. The custom format will be added to the list under Format Inspector > Cell > Data Format.

     

    Copying a custom cell in Numbers 2 and pasting it into Numbers 3 does not work. The pasted cell ends up as text.

     

    Numbers 2 is still on your computer, in a folder called iWork '09 inside your Applications folder. I find it handy to have icons for both versions on the Dock.

     

    Regards,

    Ian.

  • by SGIII,

    SGIII SGIII Nov 8, 2013 4:49 AM in response to Newto
    Level 6 (10,796 points)
    Mac OS X
    Nov 8, 2013 4:49 AM in response to Newto

    Yes, forgot to recommend this thread containing useful workarounds .

     

    SG