Results 1 to 6 of 6

Excel 2007 : Weird result from concatenation

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Montreal
    MS-Off Ver
    Excel 2003
    Posts
    6

    Wink Weird result from concatenation

    I usually have no problems using concatenation but I am having a formatting problem for which I have not been able to find a solution so far. Perhaps some of you have seen this before and have a suggestion for me. So here goes:

    I have a text value in cell A1: "Incomplete process"
    I have a numerical value in cell B1: 52.9 (this is derived from another sheet in the workbook)
    I am using this simple formula: =CONCATENATE(a1," ","at"," ",B1," ","per cent")
    I am getting the following result (actually it's what I want): Incomplete process at 52.8571428571429 per cent
    I like precision just as much as anyone else, but this is a bit overboard... How can I simply get 52.9 instead of that elongated number? This is in Excel 2007.

    Any suggestions?

    Thanks!
    Last edited by magnanr; 07-18-2012 at 12:13 PM. Reason: Solved

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