| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
importing csv file
i am generating a csv file that i'm importing to excel. one field is string of numbers, which i need to display exactly as it is in csv file. for example, if 2777380003, is in the csv file, i want to see that exact same string in excel, not scientific notation which seems to be the default. i tried adding a single quote in the csv file, like this, '2777380003, but the single quote is displayed in excel until i double click the cell. is there a way to denote no formatting inside a csv file? thanks -- godzooky ------------------------------------------------------------------------ godzooky's Profile: http://www.excelforum.com/member.php...o&userid=32424 View this thread: http://www.excelforum.com/showthread...hreadid=521911 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing MM:SS From Tab Delimited File and Charting | Charts and Charting in Excel | |||
| Importing a text file into Excel with too many rows? | Excel Discussion (Misc queries) | |||
| Importing an address file (that was pasted into a Word doc) into E | Excel Discussion (Misc queries) | |||
| How do you open a template at startup? | Excel Discussion (Misc queries) | |||
| Importing .txt data files increases .xls file size | Excel Discussion (Misc queries) | |||
Threaded Mode
