+ Reply to Thread
Results 1 to 4 of 4

Combining Columns / Reducing Decimal Places

  1. #1
    Registered User
    Join Date
    03-05-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    7

    Combining Columns / Reducing Decimal Places

    Hey all,

    I'm combining two columns of data, both columns are composed of a long series of numbers that are converted into a percentage.

    I'm trying to combine these two columns to have "##.#% / ##.#%" represented in the third.


    Any help is appreciated!

    Decimal,percentages.xlsx
    Attached Files Attached Files
    Last edited by chesapeake_catskills; 04-29-2015 at 12:54 PM.

  2. #2
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Combining Columns / Reducing Decimal Places

    Quote Originally Posted by chesapeake_catskills View Post
    I'm combining two columns of data, both columns are composed of a long series of numbers that are converted into a percentage. I'm trying to combine these two columns to have "##.#% / ##.#%" represented in the third.
    Attachment 392022
    Something like:
    Please Login or Register  to view this content.
    Last edited by joeu2004; 04-29-2015 at 12:53 PM. Reason: cosmetic

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,647

    Re: Combining Columns / Reducing Decimal Places

    Something like this.....

    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Combining Columns / Reducing Decimal Places

    wrong post
    Last edited by azumi; 04-29-2015 at 01:06 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Adusting decimal places based on greatest number of places in a series
    By anelson87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2022, 01:05 PM
  2. Decreasing decimal places for multiple columns.
    By Pho6 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2013, 11:21 AM
  3. Format columns to two decimal places
    By fusion007 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-24-2011, 07:42 AM
  4. Paste two decimal number in excel without extra decimal places appearing
    By jeffery_frick in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 07:49 PM
  5. Replies: 3
    Last Post: 07-06-2005, 09:05 AM

Tags for this Thread

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