software

Hi

When formatting in Scientific, how can you keep the exponent constant
and allow the decimal point to move?
For example

If I have:
6.647E-03
1.741E-02
8.378E-02

How do I ensure that Excel keeps the E to E-3 and adjust the decimal
point?

CheersWayneLI don;t think you can as Scientific only allows decimal places to show.

Could you perhaps make this a number column and have it display the required
number of dp's?

quot;WAYNELquot; wrote:

gt; Hi
gt;
gt; When formatting in Scientific, how can you keep the exponent constant
gt; and allow the decimal point to move?
gt; For example
gt;
gt; If I have:
gt; 6.647E-03
gt; 1.741E-02
gt; 8.378E-02
gt;
gt; How do I ensure that Excel keeps the E to E-3 and adjust the decimal
gt; point?
gt;
gt; Cheers
gt;
gt;
gt; WayneL
gt;
gt;