Numeric formatting

[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.

 

[Eric]

Custom format as 0E+0 ?

 

[Eric]

Sorry, bad answer. Didn't read closely enough.

 

[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?

 

[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.

 

[JudgeMental]

Thanks BoniM,

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

 

[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