WHY DOES 1E4 TURN INTO 1.00 E + 04? THANKS

L

Lisa B.

I'm doing data entry in excel and in my "location" column I can type 1d4,
1d3,1c3 just fine but when I try to put in 1e4 it turns into 1.00 e + 04 when
I hit enter. What am I doing wrong? Thanks, Lisa
 
L

loudfish

1e4 is recognised as scientific notation for numbers in excel. To force
text:

a. have the cell pre-formatted as "text" (Format...Cells... on the
menus).

or

b. put a single quote at the start. '1e4 instead of just 1e4

Best

Andrew
 
Top