Unabble to save month in MM/YYYY in .csv file

[dhanyaa]

Hello All,
I have to save data in .csv format to upload to my application.
my excel data is:
Month Issue Count
01/2008 Fleet 2
01/2008 HR 6
02/2008 Expense 1
02/2008 Fleet 2
03/2008 Fleet 3
03/2008 HR 2
03/2008 Other 1
when i save this to a .csv file and close and reopen, then the file looks like:
Month Issue Count
Jan-08 Fleet 2
Jan-08 HR 6
Feb-08 Expense 1
Feb-08 Fleet 2
Mar-08 Fleet 3
Mar-08 HR 2
Mar-08 Other 1
why is it happening this way.
i want the first column to be stored as mm/yyyy only.
If i click on the cell Jan-08 , the cell value it is showing is 01/01/2008.
request you to please help me regarding this.
Regards,
Dhanya

 

[GlennUK]

when i save this to a .csv file and close and reopen...

what do you open the CSV file in? A text editor I hope ... you wouldn't want Excel's automatic parsing of data into cell values to be taking place when you're examining CSV output.

 

[dhanyaa]

Hello,
thank you for your response.
I am opening the .csv file in the MS excel only.
i want to see the data in MM/YYYY format in CSV file also.

can you please let me know how to resolve this.

 

[GlennUK]

Do NOT open the CSV in Excel if all you want to do is check the format in the CSV. Open it in a text editor for the reasons I mentioned previously.

At that point you can do experiments to alter the CSV output ... but you won't know what you are getting unless you open the CSV in a text editor.