Formula Help
Dear all,
I do have a file containing cheques value as by encoded it shows figures in
dollers & sents without decimal points. I want to convert it to value with
decimal points.
value value to be converted into
50000 500.00
I tried by formatting it to Number with 2 decimal points by it adds 2 more
Zeros and value looks 50000.00. I tried a lot but nothing happening please
help me.
Thanks in advance,
Aarif
|