dulcimer

Q: Is there a way to change the default rounding principal in Pages? I want to enter exact dollar values on an invoice.

Is there a way to change the default rounding principal in Pages? I want to enter exact dollar values on an invoice.

 

Thanks!

 

Andy

iPad Air, iOS 9.3.1

Posted on Jun 13, 2016 11:10 AM

Close

Q: Is there a way to change the default rounding principal in Pages? I want to enter exact dollar values on an invoice.

  • All replies
  • Helpful answers

  • by darren.s,

    darren.s darren.s Jun 14, 2016 9:54 AM in response to dulcimer
    Community Specialists
    Jun 14, 2016 9:54 AM in response to dulcimer

    Hey there, dulcimer!

     

    From your post, I'm understanding that you're trying to change how Pages rounds your dollar values. I know making sure you have the right values, especially for an invoice, is important. The article linked below should help with those options.

     

    Pages for iCloud: Functions used to round values

     

    Thanks for using the Apple Support Communities, and have a great day!

  • by dulcimer,

    dulcimer dulcimer Jun 14, 2016 7:44 PM in response to darren.s
    Level 1 (4 points)
    iLife
    Jun 14, 2016 7:44 PM in response to darren.s

    Thanks for trying to help. I'm sorry, but I find the article confusing. I don't see anything about simply not rounding up or down. Is there a way to turn of the rounding feature, or do I have to enter a formula to adjust every time I type a figure  in?

     

    Thanks again!

  • by chris_g1,

    chris_g1 chris_g1 Jun 15, 2016 7:24 AM in response to dulcimer
    Community Specialists
    Jun 15, 2016 7:24 AM in response to dulcimer

    Hi, dulcimer!

     

    Thanks for getting back to me. You can adjust the number of decimals, and the type of input you're using (Number, Currency, etc) in a table using the side-bar on the right of Pages for iCloud (at https://www.iCloud.com).

     

    1. When you have a table created, highlight the whole table and click the "Data" tab
    2. In the "Data Format" drop down, select "Currency"
    3. In the decimals box, choose how many decimals you wish to include. Under "Currency", it defaults to two.
    4. Under the Currency option, you'll also have the ability to set the type of currency, for example "US Dollar" or "Euro".

     

    This should allow you to input exact amounts up to the specified decimal, without any rounding up or down.

     

    If you have any additional questions regarding Pages for iCloud, you can check out the link below.

     

    Pages for iCloud Help

     

    Cheers!