Number Format Problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kola5567 - 24 Jun 2005 17:54 GMT

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

Reply to this Message

Bernie Deitrick - 24 Jun 2005 19:46 GMT

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

> 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).
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message