Options

Format a Number

omyvadiyaomyvadiya Member Posts: 124
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.

Answers

  • Options
    navisionerinnavisionerin Member Posts: 161
    hi, did you try this <Precision,2:2><Standard Format,0>. if it doesnt work migth be worth trying to format it as text..
Sign In or Register to comment.