Although it does not directly respond to the question. For those that want to format numbers in engineering notation, try using this format\cells\number\custom format:
##0.0E+0;[red]-##0.0E+0
The numer of places after the decimal point can be adjusted as usual from the toolbar at anytime.
I have a large list of data from a structural analysis package, which contains the following data for each record:
member, loadcase, Fx, Fy, Fz, Mx, My, Mz.
a sample extract is like this
2181,152,643.57,4083.5,0,0,0,-41141
2182,152,643.57,4083.5,0,0,0,-28890
2183,152,643.57,4083.5,0,0,0,-9563.2...
