i have a spreadsheet that has one of its columns listing various product part numbers. a few of those numbers are like this:
10E0040
10E0041
etc, thru to 10E0049
Excel keeps automatically making the value of these (even if i enter it as a number) as 1E+41, 1E+42, etc. if i multiply all by 1 to make them into a number, it makes it like 10000000000000000000000000, instead of reading what i type in. these part numbers need to read as numbers because my list is sorted by part number. some part numbers have letters in them, some don't. how do i turn this function off? i do not know code, so any help other than code will be greatly appreciated!!!
TIA!
10E0040
10E0041
etc, thru to 10E0049
Excel keeps automatically making the value of these (even if i enter it as a number) as 1E+41, 1E+42, etc. if i multiply all by 1 to make them into a number, it makes it like 10000000000000000000000000, instead of reading what i type in. these part numbers need to read as numbers because my list is sorted by part number. some part numbers have letters in them, some don't. how do i turn this function off? i do not know code, so any help other than code will be greatly appreciated!!!
TIA!