Late to the thread. If you haven't figured this out, I found it in the help by searching for "scientific notation" and found that the help screens don't show this everywhere:

E+

Scientific notation. If any of the strings "E+", "E-", "e+", or "e-" are contained in the format string, the number is formatted using scientific notation. A group of up to four "0" characters can immediately follow the "E+", "E-", "e+", or "e-" to determine the minimum number of digits in the exponent. The "E+" and "e+" formats cause a plus sign to be output for positive exponents and a minus sign to be output for negative exponents. The "E-" and "e-" formats output a sign character only for negative exponents.

 Albert

On 02/04/2013 1:11 PM, jan johansen wrote:
OK. Struggling with display format.
I can't quite seem to force scientific notation.
So a number like this 0.000028, I would want to display as 2.8E-5.

Suggestions appreciated.




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.3267 / Virus Database: 3161/6220 - Release Date: 04/02/13




Reply via email to