Hello All,
I have to convert the excel data provided by the user to .csv file to upload to BW.
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.
Is there any other way i can format calmonth to be able to load to BW through.csv file.
request you to please help me regarding this.
Regards,
Dhanya