Results 1 to 3 of 3

Fixied Decimals with CONCATENATE

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2009
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Fixied Decimals with CONCATENATE

    Hello Again,

    Same spreadsheet as yesterday's question. I'm converting metric to British values and have no problem with fixing the decimals when displaying the number. However, I'm wanting to CONCATENATE the unit of measure to the conversion and end up with 12 places beyond the decimal.
    Entered formula is:
    =CONCATENATE(CONVERT(T5,"cm","in")," in")
    Results in 159.055118110236 in

    But = CONVERT(T5,"cm","in")
    Results in 159.1 which is what I want.

    Any ideas?
    Last edited by TimmyK; 06-11-2009 at 12:27 PM.

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