I do not believe this can be used with the FORMAT function. It can be used in display formats.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, April 03, 2013 8:02 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: scientific notation I had found that but haven't seemed to be able to do the format. -----Original Message----- From: Albert Berry <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> (RBASE-L Mailing List) Date: Wed, 03 Apr 2013 18:32:55 -0600 Subject: [RBASE-L] - Re: scientific notation 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<http://www.avg.com> > Version: 2013.0.3267 / Virus Database: 3161/6220 - Release Date: 04/02/13 > >
