Skip to Content
0
Former Member
Jan 09, 2012 at 02:59 AM

Change format date automatically

39 Views

HI ALL,

I export data from SAP (standard report) to spreadsheet (excel 2007). and in the posting date column appears number. i have to change the format used to date manually first, so that the number changed to date.

is there a way so that it can be done automatically ? i mean when i export data the column posting date contains date not number.

Thanks & best regards,

Saiful arif