Number Format Problem

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

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


"kola5567" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> kola5567
> ------------------------------------------------------------------------
> kola5567's Profile:
http://www.excelforum.com/member.php...o&userid=24614
> View this thread: http://www.excelforum.com/showthread...hreadid=382015
>