how do I keep keep numbers in a csv format?
 

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
dataimport text file and in the window that opens select all file types *.*
and it will also start the wizard


Regards,

Peo Sjoblom

"David B" wrote:

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?