ExcelBanter - Keeping the exponent at a fix value in Excel

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Keeping the exponent at a fix value in Excel (https://www.excelbanter.com/excel-worksheet-functions/63930-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 02:14 AM.