+ Reply to Thread
Results 1 to 10 of 10

Decimal places in a concatenation

Hybrid View

  1. 11-24-2006, 07:03 AM #1
    ResulG
    ResulG is offline
    Registered User
    Join Date
    11-17-2006
    Posts
    34

    Decimal places in a concatenation

    Hi,

    How would I remove the decimal places when concatenating?
    To be more specific, i want to set the number to two decimal places.

    Thanks

    ResulG
    Reply With QuoteRegister To Reply
  2. 11-24-2006, 07:06 AM #2
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    If I understand corrrectly,
    use your concatenate after left(),mid() and right() functions to avoid decimals separator ...

    HTH
    Carim
    Reply With QuoteRegister To Reply
  3. 11-24-2006, 07:07 AM #3
    Bryan Hessey
    Bryan Hessey is offline
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Carim
    Hi,

    If I understand corrrectly,
    use your concatenate after left(),mid() and right() functions to avoid decimals separator ...

    HTH
    Carim
    or *100



    ---
    Si fractum non sit, noli id reficere.
    Reply With QuoteRegister To Reply
  4. 11-24-2006, 07:12 AM #4
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Bryan ...

    Why make it simple ...
    when you can make it difficult ... !!! lol ...

    Well done much smarter ...

    Cheers
    Carim
    Reply With QuoteRegister To Reply
  5. 11-24-2006, 07:19 AM #5
    Bryan Hessey
    Bryan Hessey is offline
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Carim
    Bryan ...

    Why make it simple ...
    when you can make it difficult ... !!! lol ...

    Well done much smarter ...

    Cheers
    Carim
    just something I spotted a while ago, I guess what may really be sought is something like

    =Text(A1,"#.00")

    or some variation, but we can only answer the question as we believe it was asked.

    ---
    (master of mis-interpretation)
    Reply With QuoteRegister To Reply
  6. 11-24-2006, 07:22 AM #6
    Carim
    Carim is offline
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Bryan ...

    Once again spot on ...


    Carim
    Reply With QuoteRegister To Reply
  7. 11-24-2006, 07:16 AM #7
    ResulG
    ResulG is offline
    Registered User
    Join Date
    11-17-2006
    Posts
    34
    Yes but this number will change and I dont think this suggestion will do the work.
    I tried (A1,"0.00") but to no avail.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1