I am importing data from a program at work. The data come in in the format of ###@##(three numbers, a letter, and then 2 more numbers). The problem is that when a code such as 123E04 is imported, excel thinks it means 1.23E+04. This is a problem becasue the data I need is the E04 part. (I use the RIGHT(cell,3) formula to get the portion I want.) Any ideas on how to get the number in the format I want? I have tried changing the cell characteristics, and all kinds of stuff.

Thanks