STOP auto format of cell contents

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a problem. I am entering a list of items we have in inventory, the
serial numbers are a combination of numbers and letters. a few have numbers
to start and end in E77.

an example is 3934576E28

no matter what I do Excel changes the cell format to scientific and CHANGES
the data in the cell from above to 3.93E+34

I BEG someone to help me stop excel from automatically doing this. I need to
make multiple sheets, and workbooks, and I don't want to have to go and
manually format EVERY cell I want to have this type of SN in to "text" right
now I have other cells in the list of data as different types of numbers, and
need them that way. there HAS to be a settig "stop auto change of cell
format" or something. Otherwise I must manually go in and format oh 500 some
randomally placed cells in 20 some workbooks... then re-enter the data.
 
Preformat the cells as Text, or start each entry with an apostrophe (')
to bypass XL's input parser.
 
Back
Top