Hello,
I want to extract the data from sample_source.xls (coming from SAP) to sample_target.xlsm but I have some problem with decimal separator (in Yield and Scrap columns) after the extraction procedure, for example: I see 3,143 in D15 instead of 3143 and 35000 instead of 35 in D16. And no value in E16 but 0 should be there.
The details with expected results are in the attached files.
Could you please help me to solve this issue?
Thank you in advance!
Try this formula in cell M6 in sample_source and copy down, then copy to column N
=IFERROR(VALUE(SUBSTITUTE(D6,CHAR(46),"")),0)
Does that give you the values you want in both M & N?
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Hi kev_,
Thank you the help!
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks