Forum Discussion

agubert's avatar
agubert
Copper Contributor
Nov 16, 2018
Solved

Excel changing cell format on combination of letters/numbers when letter "E" used.

Hello all, hope to get help..   When I type i.e. na06e1- or any combination such xxexx  (this is a location# on a shelf) it automatically changes the cell format from GENERAL to SCIENTIFIC and this...
  • Amr Qmbz's avatar
    Nov 17, 2018

    I have tried to type na06e1 in Excel,but it didn't change. I think your column has a format to change any combination to scientific. Please try to delete formats on the cells before inserting the data and then try to re-write the context.



     


     

Resources