Numeric formatting

J

JudgeMental

Hi,
I need to format numbers as 10E-3, 10E-5, or 10E-6. I need to maintain the
10E-x format. Not scientific or engineering notation. It's for recording Bit
Error Rate measurement results.
Any ideas?

Thank you for your help.
 
B

BoniM

Create a custom format for the range of:
"10E-"#
with this format, entering the value, for example 3, will display as 10E-3.
You will be able to add, subtract, average, etc...
Will that help?
 
J

JudgeMental

I probably did not give enough information in my first post.

The values I need to display need to be shown for example as 1*10E-5, or
2.3*10E-5. I will be using conditional formatting to ensure that user enters
values that are in a certain range.

Thanks again.
 
J

JudgeMental

Thanks BoniM,

When I use that formatting, it only displays "10E-". The exponent is blank.
 
R

Rick Rothstein \(MVP - VB\)

Does this Custom Format pattern do what you want?

0.0#####"*10"E+0

You will have to pick some number of decimal points (maximum) you want to
have.

Rick
 
Top