Question:
I am using fm XX:_SIMPLE_API to download a list to excel. I have used this FM numeroius times successfully but this time the user doesn't want to see 0.00 in the report. They want those fields lefdt blank.
I typed that field N and also set the field in excel as string but it keeps coming up 0.00.
Does anyone know how to stop 0.00 from showing in excel when using xxl_simple_api??
Thank you for your time!
Answer:
This is on the tools->Options->View tab, Zero Values in Excel. There's no way to do this using the Function module that you are using, but you could, after the function module call open the spreadsheet using OLE and do it that way.
_________________
Regards
R
Abap KC
SFMDR