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...

excel

Amr Qmbz
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.

Amr Qmbz

Copper Contributor

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.

agubert

Copper Contributor

Nov 27, 2018

Thank you!

Forum Discussion

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

Resources