So I've poured over many forums looking for an answer to this problem but I haven't found the right one. I want to have a fixed E+n value in scientific notation so that I can compare values simpler. I am hoping to make the numbers be displayed as XE+8 regardless of what the X value is. So that would mean 4E10 will be displayed as 400E8 and 4E4 will be displayed as .0004E8.

I have tried the 0.0#####, "E+3" format. However that is just putting it into engineering format which ends up being multiples of E+3. It will not help me if I wanted to display a value to the 8th power.


Any tips?