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.