+ Reply to Thread
Results 1 to 2 of 2

Rounding Issues

  1. #1
    Louis
    Guest

    Rounding Issues

    I know this is easy but cannot get it for the life of me. I have an entire
    column of prices that are rounded correctly, with two decimal places, but the
    source data still says 4.345, not 4.35 like I need it to (I am uploading a
    database into Quickbooks). So when I go to import the data it says it is in
    an incorrect number format, thinking the number I am trying to upload is not
    the rounded number. I have tried the paste special feature but it doesn't
    seem to work with removing the rounding format.
    Thanks,
    --
    Louis

  2. #2
    Peo Sjoblom
    Guest

    Re: Rounding Issues

    It's not rounded, it's formatted to show 2 decimals, if you want to round
    you can use a help column

    =ROUND(A2,2)

    copy down/across as long as needed, copy the help range and paste special as
    values over the old range
    or use precision as displayed under tools>options>calculations


    --

    Regards,

    Peo Sjoblom


    "Louis" <Louis@discussions.microsoft.com> wrote in message
    news:4E83189F-F5BB-4052-B6C4-55AB7368A587@microsoft.com...
    > I know this is easy but cannot get it for the life of me. I have an

    entire
    > column of prices that are rounded correctly, with two decimal places, but

    the
    > source data still says 4.345, not 4.35 like I need it to (I am uploading a
    > database into Quickbooks). So when I go to import the data it says it is

    in
    > an incorrect number format, thinking the number I am trying to upload is

    not
    > the rounded number. I have tried the paste special feature but it doesn't
    > seem to work with removing the rounding format.
    > Thanks,
    > --
    > Louis




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1