Skip to Content

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

Export to Excel - In text Format

Hi All,

I'am trying below scenario,

1) Created Query , where it has Account number

2) some times Account Number Start From 00 (Ex: 00012345)

3) When I export it to Excel with extension .xls, it is taking only 12345

4) but I want complete number . i.e 00012345 in excel

because , by default MS excel will take it in general format. but I need this column in 'Text' format 

How I can achive this. any work around suggestion also appriciable

Thanks & Regards

M G Hegde

Former Member
Former Member replied

Thank you Nagarajan

I followed this thread and issue got solved.

Solution: Added char(31) before my field

i.e Select CHAR(31) +T2.[DflAccount] AS "ACCOUNT NUMBER"  from OCRD T2

Thanks to Suda Sampath

0 View this answer in context

Helpful Answer

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