| 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? |
| 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) | |||
Threaded Mode
