I have a small problem using format cells.I have tried to format the cells to "engineering mode" which is nearly the same as scientific mode.The difference is whenever I write 0,001 I want the outcome to be 1E-3 not 100E-5. So far i have tried to create a userdefined mode which is ##0E+0.So my question is if you are able to force open office to use E-3, E-6 and so on, the indices corresponding to mili, micro, nano etc.And if not, is it possible that someone could develop such a mode?

Please help.

I didn't find the right solution from the Internet.

https://forum.openoffice.org/en/forum/v … hp?t=16858
eLearning Platform Example