how do I keep keep numbers in a csv format?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to put CC numbers in to a data base using a csv format but every
time I save it as .csv it puts my CC numbers into scientific notation. Any
ideas pn how to fix that?
 
Change the file extension to txt and import it with the text import wizard
and in step 3 select text under column data format
You can actually keep the CSV extension and open it via
data>import text file and in the window that opens select all file types *.*
and it will also start the wizard


Regards,

Peo Sjoblom
 
Back
Top