hi pple,

i would like to insert a vba code where i want to convert an amount of 5,402,203 into 5.40M; is it possible because i been using "##,##0,\M" but it's giving me 5,402M instead of 5.40M becoz 5,402M sounds like 5 thousand and 4hundred and 2 millions.

thanks.