Hi,
I have a input value like 20070913 and i need to change it to the format 2.0070913E7. I am using arithmetic function FormatNum for this. I gave the Number format as 0.#######E0. Its working fine for all conditions but when the input value is something like 00010101, its results in 1.0101E4..I require the output as 0.0010101E7.
Pls help me solving this issue.
Regards,
Radhika