+ Reply to Thread
Results 1 to 6 of 6

How to enable comma style in real-time?

  1. #1
    Registered User
    Join Date
    12-01-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    22

    Question How to enable comma style in real-time?

    I'm using Excel 2013 and I'm aware of the comma style but the problem I'm facing is that it applies after I hit enter or move to another cell. Since the numbers I enter into cells are big, I want comma style as I'm typing into cells, so I know if I'm entering the numbers right. How should I do it?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to enable comma style in real-time?

    There is no built-in way to do this with comma style, or any other format. You could do it using a UserForm and VBA, and it would be a little complicated. If you provide a sample file and indicate which cells are affected, I'll see if I can find some time to do a demo for you.

  3. #3
    Registered User
    Join Date
    12-01-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    22

    Re: How to enable comma style in real-time?

    Thanks for the reply. I need it to be active in the entire workbook I'm working on not specific cells.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to enable comma style in real-time?

    Here's how my idea would work. Every time the user selects a cell, a userform pops up. In this case it would be a very small form with just a textbox. The textbox can by formatted dynamically by VBA code every time the user types another character. Then when the user is done typing, he clicks a little button to close the form, and the cell now has the value. It can certainly work for every cell in the entire workbook if that's what you need.

    If that is too cumbersome, then I am hoping others will join in with other ideas.

  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    2,957

    Re: How to enable comma style in real-time?

    Not sure if it works with Excel 2013, but just type the number with the commas.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: How to enable comma style in real-time?

    This is about as close as you can come. You can select any cell, and edit it in the userform to see the format change dynamically.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Indian Style comma separator
    By Bikash Shaw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-02-2013, 05:04 AM
  2. numbers with `comma style` in text format
    By Vogelmann in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2012, 11:37 AM
  3. Excel 2007 : Default Comma Style
    By navajo_23 in forum Excel General
    Replies: 5
    Last Post: 03-24-2010, 11:02 AM
  4. Change the 'comma style' button function
    By Jimmyharders in forum Excel General
    Replies: 1
    Last Post: 06-20-2007, 08:11 AM
  5. comma in indian style
    By Sattu in forum Excel General
    Replies: 1
    Last Post: 06-06-2006, 08:00 AM
  6. Applying Indian comma style
    By NAVEEN in forum Excel General
    Replies: 1
    Last Post: 02-22-2006, 05:00 AM
  7. [SOLVED] Currency, Percent and Comma Style buttons
    By Leslie Coover in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-08-2006, 09:10 PM
  8. India comma style in negative but in brackets
    By shrinivas in forum Excel General
    Replies: 5
    Last Post: 06-20-2005, 09:05 AM

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