How to make all the numbers in correct format? As my table looks in irregular format? It should show right to left including .00 as shown in attachment

How to make all the numbers in correct format? As my table looks in irregular format? It should show right to left including .00 as shown in attachment. And also it should be separated by comma(eg., 1,550.00, 145,987.65)total

And also how to highlight the total value.

Hey @johns

you can try this :slight_smile:

String.Format("{0:0,0.00}", 145987.65) 

or

String.Format("{0:n}", 145987.65)

or simplest way

145987.65.ToString("N")

output - 145,987.65

Regards…!!
Aksh

2 Likes