+ Reply to Thread
Results 1 to 10 of 10

Text string added causes decimal issue

  1. 06-12-2024, 06:21 PM #1
    cdhamo
    cdhamo is offline
    Registered User
    Join Date
    05-05-2013
    Location
    Australia
    MS-Off Ver
    Excel 365 Windows (V 2405 Build 16.0.17628.200006)
    Posts
    34

    Text string added causes decimal issue

    Any help would be much appreciated - the file is attached: TempUpload2.xlsx

    I have test data in Sheet1.

    I want to add a text string to the end of the values however, when I add the string to the end of the formula, it changes it from 1 decimal to 14 decimals.

    How can I fix this to for example 1 decimal, please?

    Thank you so much for your assistance.
    Reply With QuoteRegister To Reply
  2. 06-12-2024, 06:26 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,343

    Re: Text string added causes decimal issue

    Have a look at the TEXT() function when you need to convert a number to text: https://support.microsoft.com/en-us/...8-93d29371225c
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 06-12-2024, 06:29 PM #3
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Text string added causes decimal issue

    Try this, copied down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 06-12-2024, 06:34 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Text string added causes decimal issue

    If you have upgraded to 365, then all in one go:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 06-12-2024, 06:38 PM #5
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,918

    Re: Text string added causes decimal issue

    Your column header is "Years" so appending text to the calculation is redundant. But, you can use custom number format:
    0.0 "Years" for that column and still be able to use the calculation results elsewhere.
    Attached Files Attached Files
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  6. 06-12-2024, 07:42 PM #6
    cdhamo
    cdhamo is offline
    Registered User
    Join Date
    05-05-2013
    Location
    Australia
    MS-Off Ver
    Excel 365 Windows (V 2405 Build 16.0.17628.200006)
    Posts
    34

    Re: Text string added causes decimal issue

    Quote Originally Posted by TMS View Post
    Try this, copied down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Fabulous - nice and easy. Thanks so much.
    Reply With QuoteRegister To Reply
  7. 06-12-2024, 08:00 PM #7
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2502 and WPS V2024(12.1.0.18543)
    Posts
    3,842

    Re: Text string added causes decimal issue

    Pls try this formula and drag down

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    365 office version
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 06-12-2024, 08:02 PM #8
    cdhamo
    cdhamo is offline
    Registered User
    Join Date
    05-05-2013
    Location
    Australia
    MS-Off Ver
    Excel 365 Windows (V 2405 Build 16.0.17628.200006)
    Posts
    34

    Re: Text string added causes decimal issue

    Yes great thank you - nice & easy.
    Reply With QuoteRegister To Reply
  9. 06-12-2024, 08:06 PM #9
    wk9128
    wk9128 is offline
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2502 and WPS V2024(12.1.0.18543)
    Posts
    3,842

    Re: Text string added causes decimal issue

    @cdhamo You're Welcome. Glad to help . Thank You for the feedback.

    If you finally get a solution please mark your thread as SOLVED:
    - Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
    - you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
    was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
  10. 06-12-2024, 10:23 PM #10
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,997

    Re: Text string added causes decimal issue

    Quote Originally Posted by cdhamo View Post
    Fabulous - nice and easy. Thanks so much.
    You're welcome.



    You may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    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)

Similar Threads

  1. Merging Text and Numbers Together Decimal places not showing issue
    By 17mahmoods in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2022, 01:23 AM
  2. [SOLVED] Added text to formula, but formula response to one decimal point.
    By nickpavlov in forum Excel General
    Replies: 3
    Last Post: 09-29-2021, 03:39 AM
  3. [SOLVED] How do I create text string using hh:mm without is changing to decimal fraction?
    By greencatpetal in forum Excel General
    Replies: 5
    Last Post: 01-22-2020, 03:15 PM
  4. Pasted text string appears as number with ten decimal places - How do I convert back ?
    By fallwire in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-19-2017, 12:44 AM
  5. Forcing 2 decimal points to value added to text string
    By Brelin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-03-2014, 07:19 PM
  6. Decimal issue while sum numbers with two decimal places only
    By anis.pt in forum Excel General
    Replies: 4
    Last Post: 12-26-2012, 05:37 AM
  7. [SOLVED] Sorting dates with added text issue.
    By skyping in forum Excel General
    Replies: 6
    Last Post: 11-26-2012, 09:38 PM

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