how do I keep keep numbers in a csv format?

[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?

 

[Guest]

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