| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Change CSV-load cell format from GENERAL to TEXT for numbers?
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? |
|
#2
|
|||
|
|||
|
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. -- Earl Kiosterud www.smokeylake.com "Morena Chris Matthews" <Morena Chris wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change text format .126 to number format 0.126 ? | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
| Cell text color change | Excel Discussion (Misc queries) | |||
Hybrid Mode
