format the cell as scientific. In the Format Menu - Select Cells - Numbers -
Scientific

"elwilliamson" wrote:

Is there a way to format numbers in excel in engineering format where the
exponent is always a multiple of 3?

Examples
2.6e3
34.7e-9
But not 3.47e-8