cullen15
Level 1 (0 points)

Q: Custom Data Format

I am using the new version of numbers and cannot find an option for custom data format. Has it been removed or am I missing something? Can someone point me out where it is? Either that, or let me know how to get a bigger currency list as the currency I am wanting is not there.

MacBook Pro, OS X Mountain Lion (10.8.3)

Posted on Oct 30, 2013 12:25 PM

by Jerrold Green1,Solvedanswer
Jerrold Green1 Jerrold Green1
Level 7 (30,001 points)
A:

You are correct in guessing it has been eliminated. Send Feedback to Apple via the Numbers menu to register your opinion.

 

Jerry

Posted on Oct 30, 2013 12:28 PM

Close
cullen15

Q: Custom Data Format

  • All replies
  • Helpful answers

  • by Jerrold Green1,Solvedanswer

    Jerrold Green1 Jerrold Green1 Oct 30, 2013 12:28 PM in response to cullen15
    Level 7 (30,001 points)
    Oct 30, 2013 12:28 PM in response to cullen15

    You are correct in guessing it has been eliminated. Send Feedback to Apple via the Numbers menu to register your opinion.

     

    Jerry

  • by cullen15,

    cullen15 cullen15 Oct 30, 2013 12:34 PM in response to Jerrold Green1
    Level 1 (0 points)
    Oct 30, 2013 12:34 PM in response to Jerrold Green1

    Super. Go Apple.

  • by cullen15,Helpful

    cullen15 cullen15 Nov 3, 2013 1:59 AM in response to cullen15
    Level 1 (0 points)
    Nov 3, 2013 1:59 AM in response to cullen15

    Ok there is a small workaround to this. Open the old iWork version of Numbers, create a custom data format, enter data into a cell with the format set as your custom setting, copy that cell, open the new version of Numbers, paste the cell somewhere and this custom data format will now appear at the bottom of the Data Format list.

  • by Yellowbox,

    Yellowbox Yellowbox Nov 3, 2013 2:30 AM in response to cullen15
    Level 6 (10,515 points)
    Mac OS X
    Nov 3, 2013 2:30 AM in response to cullen15

    Hi Cullen,

     

    I tried this with both

     

    Leading Zeroes: enter 1 to display 0001 and

     

    Date: enter 3 November 2013 to display Nov 13 (short month and short year). My region's date format is Day Month Year. i.e. the 3rd of November 2013 .

     

    Both formats worked in Numbers 2. After copying and pasting to cells in Numbers 3, I did not see a new format at the bottom of the Numbers 3 Data Format list. The cells in Numbers 3 showed either "Actual" or "Text" in the bottom left of the window. So I don't think the custom format carried over.

     

    Could you post a screen shot to demonstrate?

     

    Regards,

    Ian.

  • by cullen15,

    cullen15 cullen15 Nov 3, 2013 10:02 PM in response to Yellowbox
    Level 1 (0 points)
    Nov 3, 2013 10:02 PM in response to Yellowbox

    Hi Ian,

     

    Yes you are right. The same thing happened to me. I know why. What I originally did was save the Numbers 2 document, then opened it up in Numbers 3, that is how the custom format carried over, not by copying and pasting. If you do that, your custom format should appear at the bottom of the Data Format drop down list.

     

    Not ideal especially if you need to create a new template, but for the moment it's the only way I can see to create a custom format in Numbers 3.

     

    Cheers. Cullen.

  • by Yellowbox,

    Yellowbox Yellowbox Nov 4, 2013 3:43 AM in response to cullen15
    Level 6 (10,515 points)
    Mac OS X
    Nov 4, 2013 3:43 AM in response to cullen15

    Hi Cullen,

     

    Thank you for this workaround. I did as you said, and it works, unlike copy and paste from Numbers 2.3 to Numbers 3.0 .

     

    In Numbers '09 (version 2.3) I created two Custom formats.

     

    Column A is the inbuilt Date and Time format showing only the Date (my region's date format is Day Month Year).

    Column B is a Custom Format to show short Month, space, short year.

    Column C is the inbuilt format for Number.

    Column D is a custom Format to show leading zeroes.

    Screen Shot 2013-11-04 at 9.59.38 pm.png

     

    Then I did as you said and saved the Numbers 2 document (as a document for future use, not as a Template, because I am not sure how Templates are shared between the two versions on Numbers).

     

    Then File, option key > Save As... a new name to preserve my original from harm by Numbers 3.0 .

     

    In Numbers 3, (as you said) open the spare copy and the Custom formats are indeed listed. Format Inspector > Cell > Data Format

     

    Screen Shot 2013-11-04 at 10.14.18 pm.png

     

    And they do work. Here is where I edited the cell content by entering new values from the keyboard:

     

    Screen Shot 2013-11-04 at 10.19.58 pm.png

     

    I shall place a link to this thread on the thread named "Workarounds in Numbers 3.0?"

     

    https://discussions.apple.com/message/23622372#23622372#

     

    Thanks for this.

     

    Regards,

    Ian.

  • by bemental,

    bemental bemental Dec 29, 2013 12:21 AM in response to cullen15
    Level 1 (0 points)
    Dec 29, 2013 12:21 AM in response to cullen15

    I stumbled upon this thread trying to create a custom date format that would allow me to display only the Day of the Week based upon the date of a different cell.

     

    Ended up concatenating a hidden date row/cell to get the results desired.

     

    Formatted the date in the hidden cell as "Sun, Dec 29, 2013" and pulled a function of "=left (cell, 3)".

     

    Screen Shot 2013-12-29 at 3.21.13 AM.png