Skip to Content
0
Former Member
Jan 08, 2008 at 09:45 AM

Format Number

25 Views

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