google sheetsgoogle-sheets-cell-format
In Google Sheets when I enter
10E-12
in a cell formatted for scientific notation, it automatically turns the number into
1E-11
Though technically correct, this is really annoying when comparing numbers between cells. Is there a way to specify the power to which the number should be raised in Google Sheets?
The following custom number format mask will produce the desired results without losing the accuracy of the underlying value.
[>999999]0.0,,\M;[>999]0.0,\K;0
It appears that the hours' field is required for time to be recognized as such. Enter 0:mm:ss.SSS (assuming decimal dot; could be a comma in your locale), for example 0:22:22.222
The default format for duration does not include the milliseconds' field, eg. use a custom one:
The first field should be "elapsed" to make the format a duration format: e.g., 70 minutes will stay 70 minutes without carrying over to hours.
Best Answer
To specify power of exponent, such as to powers of 3, 6, 9, etc, specify the number of places in the format.
e.g.
##0.00#E+##Note that there are 3 places on the left of the decimal and 3 places on the right of the decimal.
The powers will increase or decrease by multiples of 3.
The exponential display can be formatted as you wish with 0 or #.