Recently Browsing 0 members
No registered users viewing this page.
hi, i have the following function to get a number in scientific format.
my input is 12360
what i get using the below function = 1.236E+004
What i require is 1.236E4
how do i achieve this. i do not require the '+00'prefixing '4 or whatever' in my o/p.
I would like to know if it's possible to convert a number with the function StringFormat in order to place a space (or whatever) at the thousands pos.
1000000 ;before 1 000 000 ;after
Please don't suggest a solution with some strings functions, the point of this topic is to know how to do it with the function StringFormat since what I've found on internet does not work.
Thanks for anyhelp;