Q&A Help Tips


Numbering the records automatically in Mass Update
Each new database starts with 1.

  1. Make a field called "ID:  >" (3 spaces if up to 999 records), Numeric with 0 decimals (N0)
  2. Mass Update.  You may wish to Sort by another near key field
  3. #1=@nmb
  4. Ctrl+F10 to Update rest (F10 skips)

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://www.quickanswer.com/

https://web.archive.org/web/20070218021140/http://www.quickanswer.com/home.htm