Results 1 to 3 of 3

Thread: Adding fixed percentage to entire column of prices problem?

  1. #1

    Adding fixed percentage to entire column of prices problem?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello, using OFFICE 2010 I wish to add 5% to a list of prices, the different prices are all in the same column, I searched the net and found these instructions:

    If you wish to add 5% to a row of prices, in a cell on your page type 1.05, then select that cell and copy it. Now select your cells that contain the prices. Then from the Edit Menu select Paste Special and from the dialog box check multiply.

    So I typed 1.05 into an empty cell and this works BUT problem is it adds more than 2 decimals so for example $3.10 now becomes 3.255 I then try

    Format / Custom then in the "Type" box put $0.00

    but same result. I tried this in Open Office and it works perfect but I am at my wits end on getting this to work in Office 2010, help please anyone?

  2. #2
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Works fine for me.
    Hope that helps

    Roy

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Can you post an example sheet, showing the problem with the decimal places ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •