Numbering the records automatically in Mass Update
Each new database starts with 1.
Tip: Recover DTF to ensure that @nmb starts off at 1
Adjust the F0001 name to F0403 in Excel
=IF(MID(A1,1,2)="F0","F"&TEXT(VALUE(MID(A1,2,4))+402,"0000"),A1)
https://web.archive.org/web/20070218021140/http://www.quickanswer.com/home.htm