11-14-2022
04:13 PM
- last edited
3 weeks ago
by
JackLacava
Hi
I am getting some large numbers out of my confirmation rules and I am looking for ways to format the output so it is easier to read. Preferably commas between the thousands, millions, billions... etc but would also like to know what other formatting options are available as well.
Currently my output is the below and I am trying to make the 'math.Round(Acc1,2)' part easier to read.
Does anyone know of a resource that lists the different formatting options?
Or just how to add the comma seperators?
Thanks
Simon
Solved! Go to Solution.
11-14-2022 11:14 PM
I think what are you looking for is this:
"A#MCF0015050_PLG = " & Acc1.ToString("#,###.00")
Here is the decent read on formatting:
https://www.thevbprogrammer.com/VB2010_04/04-01-FormattingNumbersDateStrings.htm
It's written infinitely better than Microsoft Learn article on formatting 🙂
11-14-2022 11:14 PM
I think what are you looking for is this:
"A#MCF0015050_PLG = " & Acc1.ToString("#,###.00")
Here is the decent read on formatting:
https://www.thevbprogrammer.com/VB2010_04/04-01-FormattingNumbersDateStrings.htm
It's written infinitely better than Microsoft Learn article on formatting 🙂
11-15-2022 02:41 AM
Thanks that is exactly what I was after.
No more counting zeros 😀
11-15-2022 02:48 AM
Hi, this returns the string depending on the culture settings of the individual user.
XXX.ToString(cultureInfo.InvariantCulture))
Here is some information on culture and strings: