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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell format, want 100 to display as 1.00 4
Conditional formatting for changing data 4
Payroll 1
Transpose or Macro? 7
Can's work this out, probably easy for an expert! 4
Counting with multiple criteria in separate Columns 6
Weighted Average 7
Convert 04:03:00 (hh:mm:ss) to 04:03 (mm:ss) 3

Back
Top