Dear All,
I have an requirement ,to upload the excel sheet data into a report program for updating material master. In excel sheet , I have one column with date values. I want to validate the value entered by user in excel sheet is in DDMMYYYY.
I am trying to do it as below:
SET PROPERTY OF lv_selection 'NumberFormat' = '[$-14409]dd.mm.yyyy;@'.
but it is not working. acn anyone has worked on similar kind of req?
and also i have one more question , if i enter the value in excel cell starting with 0 , zero is going off.
Thanks,
Arpita