Importing Text and Numbers

  • Thread starter phillips_sarah_ann
  • Start date
P

phillips_sarah_ann

I am having a problem with importing a combination of text and or
numbers into a table. The datatype for the field is set to text, but
when the record has only numbers in it , it is showing it in scientific
format rather than general format which is what I need. Does anyone
have a solution where by I can have the number in general format but
without losing the leading zero.

Any help much appreciated.
 
Top