Change CSV-load cell format from GENERAL to TEXT for numbers?

G

Guest

Article ID: 269370 "Last digits are changed to zeroes when you type long
numbers in cells of Excel" explains half of the problem.

I am loading a CSV file with Credit Card numbers and loosing the last digit.
The workaround is to rename the file as *.txt and loading the file and
setting the column's format to Text.

Can't one customize Excel 2003 to default the cell format to Text?
 
E

Earl Kiosterud

Morena,

You can record a macro while you're going through the Text Wizard that the
..txt extension evokes. That will record all your choices. Macros let you
customize and automate virtually anything you do with Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
Number in text format in CSV file 3
Open csv file with Leading Zeros 1
csv not importing numbers stored as text 1
Cell format on reading .csv file 3
Scientific notation of CSV 4
CSV to Excel 3
Comma Delimited (CSV) Files 1

Top