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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers in cells not responding to Format Cells 3
Index/Match with text-looking numbers 1
Excel Conditional Formatting 1
import and saving data 1
Date formatting 4
Extract Phone Number Forumula 7
Help on Code Snippet Error {Val function} 6
Automatically chnage number format of a range of cells 2

Back
Top