Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Excel cell value's for different option

Former Member

‎2007 Oct 15 2:48 PM

0 Likes
452

hi,

Is there any cell command that we can pass along with cell value to excel to mention that corresponding value in the cell is character or string etc.

for example I am passing 446000018680308 to the excel while displaying it shows 4.46E+14 I want excel to treat this as text.so that it displays number correctly.

Regards,

Karthik.k

hi,

Is there any cell command that we can pass along with cell value to excel to mention that corresponding value in the cell is character or string etc.

for example I am passing 446000018680308 to the excel while displaying it shows 4.46E+14 I want excel to treat this as text.so that it displays number correctly.

Regards,

Karthik.k

Reply
2 REPLIES 2
Read only

Former Member

‎2007 Oct 15 3:15 PM

0 Likes
414

which FM are you sing to down load data in to excel

try to using SAP_CONVERT_TO_XLS_FORMAT

Read only

Former Member

‎2007 Oct 15 3:32 PM

0 Likes
414

hi

good

there is no such cell command for this ,the value before moving it to excel save it into a text than you pass to excel it ll work fine .

thanks

mrutyun^