I am doing a project where I am entering all the file names of a folder in an excel sheet, but in the local folder, there are some files like (1.jpg, 1,pdf, 1.rar) while entering the filename into excel, I only want to enter one 1, not three times. how can I do that? filename.xaml (9.0 KB)
there is an another small problem. some filename value is decimal number so excel is cutting down the last digits after last 4 digit.
but i need the exact value.
I have done some changes in the code.
File : Duplicate.zip (7.5 KB)
for me it is not working it say filename access denied