Sometimes when I type an alphanumeric string into Excel, it converts it to...

  • Thread starter Thread starter jayztttight
  • Start date Start date
J

jayztttight

Guest
...something weird (e.g. 2.00E+14)? I use Excel on a daily basis and recently for work I have been entering in some alphanumeric codes into a worksheet, and it randomly converts these to some weird string. For instance, I type 2E14 and it converts it to 200000000000000 and the cell will show 2.00E+14. Is there any explanation/fix for this? Thanks in advance.
 
Back
Top