add comma for to a text field contain numbers - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

add comma for to a text field contain numbers

Last post 05-17-2018 11:05 AM by Hilary Stoupa. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 05-13-2018 11:22 PM

    add comma for to a text field contain numbers

    Hi all, I have a text field, mainly it stores numbers like 5520000, 10000, etc. and i want to make these numbers in thousand format with commas like 5,520,000 or 10,000. Remember its a text field not number field and i don't want to change the field data type to number. so, help me how to achieve this. Thanks
  • 05-15-2018 09:37 PM In reply to

    Re: add comma for to a text field contain numbers

    No reply by all ?
  • 05-16-2018 08:09 AM In reply to

    Re: add comma for to a text field contain numbers

    You want the actual value to contain a comma? Or do you want it to just display with a comma?
    Hilary Stoupa

  • 05-16-2018 11:41 PM In reply to

    Re: add comma for to a text field contain numbers

    I want actual value with comma. BR
  • 05-17-2018 11:05 AM In reply to

    Re: add comma for to a text field contain numbers

    I'm sure there are more elegant ways to do this, and there are a wide variety of ways my approach could go wrong (I'm not handling for people entering non-numeric data, for example, and this will only work on numbers up to quadrillions, but it should give you an idea. Save the attached file locally. Right click the file and select design. Then you can preview and give it a try.
    Hilary Stoupa

Page 1 of 1 (5 items)
Copyright © 2003-2018 Qdabra Software. All rights reserved.
View our Terms of Use.