Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Scientific Notation Without "E"

I'm trying to represent numbers in the form x*10^y instead of xE+y in LibreOffice Calc, but am not able to create a fitting custom format string.

The closest I got is this one: #"*10^"E#, which ends up with x*10^Ey.

Is there a way I can somehow hide the E without losing the correct numbers? Or any other way to achieve this formatting?

I'm aware of this question, but its more than three years old and I hoped that something might have changed since then...