Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Format
Hi,
I have a csv file with values like "01-03-01", and when i open this file in Excel this value is automatically converted into Date format. How to avoid this?. i want the text to just displayed as "01-03-01" when the file is opened in excel without getting converted!. is there a way to do this? thanks, Shiv |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Format
Hi Shiv,
Are u importing thru excel interface or programmatically? Thru Excel if u use Data-Import External Data-Import Data and then select the CSV file and follow the steps, u can modify the data type of the desired column from MDY to Text. If programmatically, then to the opentext method you can give in FieldInfo, array specifying the data types of columns. Hope this helps. Regards, Mahesh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Format
Change the name of the file to a txt file.
Then open the file and the open text files Wizard will be openned then you select delimited by select comma as the delimiter then you select the column with your data and select TEXT your data will not be converted to date Francisco Mariscal -----Original Message----- Hi, I have a csv file with values like "01-03-01", and when i open this file in Excel this value is automatically converted into Date format. How to avoid this?. i want the text to just displayed as "01-03-01" when the file is opened in excel without getting converted!. is there a way to do this? thanks, Shiv . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text Format
No, i am not doing it programatically. I just generate the CSV file and my customers need to view that file merely by double clicking the file without going thro any wizards!. is there a way of having default excel template which will not convert the data into date format? thanks, Shiv *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
Change number (in text format) to numeric format | Excel Discussion (Misc queries) | |||
how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
How do i change numbers in text format to number format? | New Users to Excel |