Exponent in Excel .xls - How can I make the result typical scientific notation?

[hugom]

Hello,

I create my certificates of calibration trough Excel, and I don´t know how can I have for the results a typical scientific notation, for instance 1.23x103, instead of the 1.23E+03 notation.

Can anyone help me ?

Thanks in advance,
Kind Regards,
Hugo

[Tim Folkerts]

Most people who use Excel (and many other software packages) are familiar with the 1.23E+03 notation, so is it really a problem?

I don't know that there is any easy way to change the notation - at least not automatically. If you type the number yourself is is possible to set the notation to look more standard - you could even put the power of ten as a superscript. You could probably get clever with text functions and find a way to have Excel change the format, but I don't know if it is worth the effort.

Perhaps someone else has a better idea???

Tim F

[Jim Wynne]

Originally Posted by Tim Folkerts

Most people who use Excel (and many other software packages) are familiar with the 1.23E+03 notation, so is it really a problem?

I don't know that there is any easy way to change the notation - at least not automatically. If you type the number yourself is is possible to set the notation to look more standard - you could even put the power of ten as a superscript. You could probably get clever with text functions and find a way to have Excel change the format, but I don't know if it is worth the effort.

Perhaps someone else has a better idea???

Tim F

I would leave it alone; anyone who's capable of critically evaluating the number should understand scientific notation; the whole idea of scientific notation is to not have to bother with superscript exponents.

[hugom]

My problem is that I got a non-conformity in my last audit because of that.

Hugo

[Jim Wynne]

Originally Posted by hugom

My problem is that I got a non-conformity in my last audit because of that.

Hugo

If you've described a quantity in a way that A) is understood by people who need to understand it and B) wouldn't change if it were expressed in some other form, then your auditor is wrong, unless there's more to this than meets the eye. What was the NC for? What "shall" was violated?

[Claes Gefvenberg]

Originally Posted by JSW05

unless there's more to this than meets the eye. What was the NC for? What "shall" was violated?

Indeed. Can you tell us more, Hugo?

/Claes

[FlavioLima]

Originally Posted by hugom

Hello,

I create my certificates of calibration trough Excel, and I don´t know how can I have for the results a typical scientific notation, for instance 1.23x103, instead of the 1.23E+03 notation.

Can anyone help me ?

Thanks in advance,
Kind Regards,
Hugo

Sorry Hugo !!!!
There's no simple way to achieve this in EXCEL. Cientific notation uses X.XXE+xx.
Most bizarre part of your post is getting non-conformity in audit. I'm just curios about it:

Which objective evidence did he/she ask you? what's clause related ?

Best regards.

FL

[Justin]

First - There is no way of getting Excel to do what you ask without rewriting the actual code of the program.

Second - The scientific notation format is the same throughout the world. It is a nationally recognized mathematical representation of a number.

I agree that it is very bizarre (I love that word) that a nonconformance would be issued for this. I am now very curious to know what "shall" was violated by the use of standard scientific notation. Almost sounds to me like your procedure calls for the number to be in the format you described. If this is so, and thats what the nonconformance was for, then just change your procedure to show either method as acceptable. Just a thought.

Good Luck