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