I have tons of excel files to rename. All excel files doesn't have a regular naming conversion. for example there are asbd.xls fdsfdh.xls

I need to change all 3000 files to something in order like 1.xls, 2.xls and up to 3000.xls

Is there a batch files that can do that?

Thx in adavnace.

There are tons of ways. I do simple ways like put all the file names into a text file then use that test file to serve as input to the next rename command.

"Best Practices", Event viewer, host file, perfmon, are in my top 10

@echo off
setLocal EnableDelayedExpansion

for /f "tokens=* delims= " %%a in ('dir/b/a-d *.XLS') do (
set /a N+=1
ren %%a !N!.XLS
)

=====================================
If at first you don't succeed, you're about average.

M2