Skip navigation

Formating free Quantity Units

315 Views 4 Replies Latest reply: Oct 26, 2012 3:35 AM by Meckermaxe RSS
Meckermaxe Calculating status...
Currently Being Moderated
Oct 24, 2012 4:17 AM

I miss a function for formating free or not included quantity units. It is not possible to format a row of cells with a weigth-unit. I know, that i could use a text-formated row, but it would be nice an practically, if such a formatingpossibility would exist.

 

Reguards.

  • Wayne Contello Level 6 Level 6 (12,820 points)
    Currently Being Moderated
    Oct 24, 2012 5:02 AM (in response to Meckermaxe)

    Make a custom format:

     

    select the cells(s) you want to format then open the cells inspector.  Select "Custom" for the weight:

    Screen Shot 2012-10-24 at 6.52.59 AM.png

     

     

    Then set the number for integer digits and decimal places as well as fixed text (like "g" for grams)

    Screen Shot 2012-10-24 at 6.57.44 AM.png

     

    Screen Shot 2012-10-24 at 6.57.53 AM.png

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.