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.

Eric
Sat May 10 14:54:00 CDT 2008

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.

Eric
Sat May 10 14:56:00 CDT 2008

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.

BoniM
Sat May 10 16:09:01 CDT 2008

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.

JudgeMental
Sat May 10 16:10:00 CDT 2008

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.

JudgeMental
Sat May 10 16:18:00 CDT 2008

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.

Rick
Sat May 10 16:19:22 CDT 2008

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" <JudgeMental@discussions.microsoft.com> wrote in message
news:3B93C5CD-1FBE-420D-965E-B49EF97F98AF@microsoft.com...
>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.