Quote Originally Posted by shg View Post
Try formatting as 0.0#####,"e3" adapted for your regional settings (note that it includes both a decimal and a comma)
Let's say the number x=0,0234
When I format the cell using notation 0.0#### the value is of course calculated right,
but when I use something like this: 0.0#####,"e3" the original value in the cell and the processed value aren't equal: 0.0234!=0,0234e3.

This doesn't solve my problem. What I want to do with the two values is that they should be displayed as:
xe(fixed exponent)
ye(fixed exponent),
no matter, what the actual x and y values are. When I format cells using the engineering notation I still get something like this:
x=0,001029628
y=0,00008481
After processing:
x=1,030e-03
y=84,810e-06

I want the numbers marked as red in the above example to be equal, no matter what x and y are.
If somebody has a macro dealing with this I would be glad to see it (I know some programming languages, but not the VBA).

Cheers.