ExcelBanter - Keeping the exponent at a fix value in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Keeping the exponent at a fix value in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/63915-keeping-exponent-fix-value-excel.html)

WAYNEL

Keeping the exponent at a fix value in Excel

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?

Cheers

WayneL

All times are GMT +1. The time now is 10:07 PM.