Showing results for 
Search instead for 
Did you mean: 

BEx Query export (numeric output MS Excel)

Former Member
0 Kudos

Hi all,

When I'm running a query in Excel the output of a date will be numeric.

After saving the query to .xls the date (i.e. 07.2006) will be formatted to a textformat. Is it possible to keep the numeric value?



Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Gopi,

My last question, is this the only way or is it possible to set some settings in SAP?


Former Member
0 Kudos

Select the whole column.

You can change format of the column using Menu Navigation Format>Cells>Number.

If you change it to Number then then month will become 7.2006 ie leading zeros will go away.



Assign points if helpful ...