Format a Number

omyvadiya

hi,
how can i format a numeric value to correct format that i require:

Wrong Format - 2,969,908
Correct Format - 29,69,908

I have used round and format both. what must be the correct parameters of format function to get the correct values.

navisionerin

hi, did you try this <Precision,2:2><Standard Format,0>. if it doesnt work migth be worth trying to format it as text..