Adding a comma between single digits in a cell
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: Adding a comma between single digits in a cell

  1. #11
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,311
    Post Thanks / Like
    Mentioned
    41 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Adding a comma between single digits in a cell

    Nice, Rick, I hadn't seen that version before. Much cleaner.
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

  2. #12
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    34,960
    Post Thanks / Like
    Mentioned
    91 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Adding a comma between single digits in a cell

    Quote Originally Posted by Eric W View Post
    Nice, Rick
    Thanks!



    Quote Originally Posted by Eric W View Post
    I hadn't seen that version before.
    Me either... I made it up on the spot. In thinking about it now, I vaguely remember doing something in a similar vein in VBA using String and Format a while ago, so maybe that was in the back of my mind when I dummied up the formula for the initial testing.
    Last edited by Rick Rothstein; Jul 21st, 2019 at 10:16 PM.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  3. #13
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    5,230
    Post Thanks / Like
    Mentioned
    49 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Adding a comma between single digits in a cell

    Quote Originally Posted by Rick Rothstein View Post
    Thanks!

    Me either... I made it up on the spot. In thinking about it now, I vaguely remember doing something in a similar vein in VBA using String and Format a while ago, so maybe that was in the back of my mind when I dummied up the formula for the initial testing.

    Congratulations Rick for the ability you have to solve it on the spot. And for sharing it with mortals.
    Regards Dante Amor

  4. #14
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    34,960
    Post Thanks / Like
    Mentioned
    91 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Adding a comma between single digits in a cell

    Quote Originally Posted by DanteAmor View Post
    Congratulations Rick for the ability you have to solve it on the spot. And for sharing it with mortals.
    Uh, I am one of the mortals also you know. I just got lucky and thought up a simple formula using a somewhat different approach, that is all.
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •