Skip to Content
0
Former Member
Jun 13, 2011 at 03:00 PM

Unable to save Calmonth in MM/YYYY format in .CSV file

134 Views

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