In excel why does 4E01 change to 4.00E+01 whenever entered?
 

In excel why does 4E01 change to 4.00E+01 whenever entered?

In excel why does 4E01 change to 4.00E+01 whenever entered?
 

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



Excel information...??? wrote:

In excel why does 4E01 change to 4.00E+01 whenever entered?

--

Dave Peterson