preset decimal with the power exponent
preset decimal with the power exponent
(OP)
Is there a means of displaying large / small numbers in engineering notation within cells of an Excel workbook.
I have access under the Format / Cells / number options box that allows either fixed decimal (category option “number”) or preset decimal places with a full engineering format for numbers (category option “scientific”).
I am looking to set the cell format to preset decimal with the power exponent forced to predefined values of 3, 6, 9 ….or -3, -6, -9 …..etc as per international engineering standards.
Any help would be appreciated.
I have access under the Format / Cells / number options box that allows either fixed decimal (category option “number”) or preset decimal places with a full engineering format for numbers (category option “scientific”).
I am looking to set the cell format to preset decimal with the power exponent forced to predefined values of 3, 6, 9 ….or -3, -6, -9 …..etc as per international engineering standards.
Any help would be appreciated.





RE: preset decimal with the power exponent
Format-Cells-Custom ##0.0E+0 OK? - - bjt
RE: preset decimal with the power exponent
Regards,
Joerd
RE: preset decimal with the power exponent
##0.00E+0
Unfortunately, the E has to stay there, since that's the command that forces the engineering notation.
TTFN