+ Reply to Thread
Results 1 to 3 of 3

Adding Decimal Places Into A String

  1. 06-23-2021, 11:14 AM #1
    @MeDaveT is offline
    Registered User
    Join Date
    08-28-2012
    Location
    Sheffield, UK
    MS-Off Ver
    Excel 2010
    Posts
    30

    Adding Decimal Places Into A String

    Hi

    I have been looking how to add a decimal into a string of text however none of the options are doing what I need it to so hoping someone can help out with a formula that I can use.

    I have a dataset which I need to take and add a decimal place two from the end.

    E.g

    9999999999999 would become 99999999999.99
    999999999990 would become 9999999999.90

    And so on.

    Any help would be greatly appreciated
    Reply With QuoteRegister To Reply
  2. 06-23-2021, 11:18 AM #2
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Adding Decimal Places Into A String

    ??? =A1/100 and format as number with 2 dp???
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
    Reply With QuoteRegister To Reply
  3. 06-23-2021, 11:19 AM #3
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,698

    Re: Adding Decimal Places Into A String

    Why not just divide by 100?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    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. 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. [SOLVED] Stop concatenate adding decimal places back
    By ethanJCB in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-13-2017, 09:24 AM
  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. [SOLVED] Converting a number with a specified number of decimal places into a string
    By lostest in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2016, 09:38 AM
  6. [SOLVED] Need to limit the number of decimal places of a number in a text string
    By Turbo Dog in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-11-2013, 07:47 PM
  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

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