Numeric formatting
 

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.

Numeric formatting
 

Custom format as 0E+0 ?

"JudgeMental" wrote:

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.

Numeric formatting
 

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

"JudgeMental" wrote:

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.

Numeric formatting
 

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" wrote:

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.

Numeric formatting
 

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" wrote:

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.

Numeric formatting
 

Thanks BoniM,

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

"BoniM" wrote:

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" wrote:

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.

Numeric formatting
 

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


"JudgeMental" wrote in message
...
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" wrote:

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.