data : var type p decimal 2.
var = 11000.00.
while downloading var its showing 11,000.00. i need to download only 11000.00 with out converting var to character field.
How to remove special character ',' without changing data type while downloading to XLS.
Moderator message: duplicate post.
Edited by: Thomas Zloch on Dec 25, 2010 4:53 PM
This is not possible with out changing the format of the cell. This is excel natural features. Forget about SAP, can you do manipulation of large number in excel with out changing the format and comma's will not come?? suppose you have a number
123123213 and it will come as 1.23E+08. To make it proper we did format as numeric or text etc..
So if you want make the format as text and then download it.
You can take reference to make the format text.
CALL METHOD iref_spreadsheet->set_format
rangename = 'PRANGE'
typ = 0
currency = 'USD'
no_flush = 'X'
error = iref_error.