Forum Discussion
Stuart Currie
Nov 06, 2018Copper Contributor
Engineering Notation Formatting Excel
Enhancement Suggestion
Engineering Notation Formatting is one of the most useful yet least documented options. This is at least true for electrical or any other field with calculations requiring unit conversions and consolidation.
##0.0E+0
This should be in a more convenient category under beside or under Scientific Category vs 2 mouse clicks and a big scroll deeper as almost undocumented option under "Custom". How does ## make you intuitively guess this means Engineering notation?
Ideally would also have option to fix the exponent . i.e so you could stay in the same units nanoseconds or millivolts even if move more than 1000 units..
A suggestion for one of my favorite tools.
No RepliesBe the first to reply