Thread: text vs number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey Duke Carey is offline
external usenet poster
 
Posts: 1,081
Default text vs number

How are you importing it?

If as a text file through the Wizard, make sure you click on that column and
assign it the Text datatype


"ESCOKS" wrote:

I have an inventory code 10E3 when I try and import it in a speadsheet it
always wants to go in as 1.00E+04 which looks to me like 10000 this also
happens for my inventory code 22E3 (2.20E+04) I tryed formmated to text but
it stil does not like it

Help!
ESCOKS