normally formatting is better left to the front end app to perform.
sometimes however this isn't always poss or desired.....
so in this case, how does your client want the following displayed?
-10,000,000
1
10
100
1,000
10,000
100,000
1,000,000
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day