Background: I made a spreadsheet and one of the columns is in units of V (volts). Since 0.224 is easier to read than 2.24E-001, for example, I have formatted this particular column as
General (most of the columns are formatted as
0.00E+0). However, the data I’m entering is easier to enter using ‘E’ (or just ‘e’). For example 41.5µA (microamps) is best entered as
41.5e-6, and 224mV (millivolts) can be entered as
224e-3. Unfortunately though, using E when entering data automatically changes the number format to
So the question is, how do I prevent the use of E when entering data from changing the number format?