Results 1 to 6 of 6

Stop concatenate adding decimal places back

Threaded View

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Staffordshire, UK
    MS-Off Ver
    2010
    Posts
    3

    Stop concatenate adding decimal places back

    Excel experts, hi!

    How do I stop concatenate adding decimal places back?

    Concatenate is referencing a simple cell containing a number formulated elsewhere and adding ":1" to the end (to give a ratio reading)

    =CONCATENATE(AF32,":1")

    The referenced cell AF32 is set to 0 decimal places, the cell containing the concatenate is set to 0 decimal places. Without concatenate, AF32 references (in any cell) as it should with no decimals, so why does concatenate add the rogue decimal places back in??? Excel tsk!!!! tsk!!!!!
    Last edited by ethanJCB; 08-31-2017 at 05:53 AM.

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. [SOLVED] Adding multiple decimal places into a cell
    By bradley_s in forum Excel General
    Replies: 4
    Last Post: 02-15-2022, 01:35 AM
  3. Replies: 5
    Last Post: 01-19-2017, 12:44 AM
  4. Concatenate with 2 decimal places
    By Deiseman in forum Excel General
    Replies: 5
    Last Post: 10-11-2016, 02:35 PM
  5. Replies: 7
    Last Post: 02-07-2011, 01:47 PM
  6. Concatenate formula not taking decimal places/currency sign
    By woodsonline in forum Excel General
    Replies: 4
    Last Post: 05-27-2009, 03:34 AM
  7. [SOLVED] Adding numbers in a column that have 3 decimal places
    By KimberlyC in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-23-2005, 09:07 PM

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