| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format numbers in chart datatable | Charts and Charting in Excel | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Mail Merge - format of numbers | Excel Discussion (Misc queries) | |||
| How do i change numbers in text format to number format? | New Users to Excel | |||
| Format of Numbers Q | Excel Worksheet Functions | |||
Linear Mode
