Hi,

To meet your original request that the numbers should display the same fixed exponent, then the numbers should look like the following

2.3455E+3
897.0-3

You can get these by formatting the numbers with

##0.###0E+0

You'll need to replace the "." ,which in my regional settings is the decimal point, with your local setting - presumably the ","

Rgds