In excel why does 4E01 change to 4.00E+01 whenever entered?
E Excel information...??? Dec 28, 2005 #1 In excel why does 4E01 change to 4.00E+01 whenever entered?
D Dave Peterson Dec 28, 2005 #2 4E01 is scientific notation for 40 (4*10^1=4*10=40) If you want to keep the cell showing 4E01 (as text), you can either preformat the cell as text or start your entry with an apostrophe: '4E01
4E01 is scientific notation for 40 (4*10^1=4*10=40) If you want to keep the cell showing 4E01 (as text), you can either preformat the cell as text or start your entry with an apostrophe: '4E01
