Number Format Problem

  • Thread starter Thread starter kola5567
  • Start date Start date
K

kola5567

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

Thank
 
kola,

Rename the file with a .txt extension, then when you open it, Excel will
step you through an import wizard, during which you can tell Excel to treat
those values as strings.

HTH,
Bernie
MS Excel MVP
 
Back
Top