Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question