Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do I prevent 'E' from automatically formatting as standard form

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 0.00E+000.

So the question is, how do I prevent the use of E when entering data from changing the number format?