Forum Discussion

Stuart Currie's avatar
Stuart Currie
Copper Contributor
Nov 06, 2018

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

Resources