auto numbering in a table

  • Thread starter Thread starter Seapeace
  • Start date Start date
S

Seapeace

I have a table with a column using auto numbering for itentification
purposes. Now I want to sort it, having the numbers stay the same but I want
to turn off the auto numbering. When I do the numbers go away. Anyway to do
this?
 
You can convert numbers to text. Select the relevant column and then do the
following:

Press Alt+F11 to display the Visual Basic Editor. Press Ctrl+G to activate
the Immediate window. Type

Selection.Range.ListFormat.convertnumberstotext

and press Enter.

Numbering will be removed from the selected column. (Note that if numbering
was applied via a style, you should also clear the numbering from the style
definition.)

You can now sort the table without any renumbering taking place.
 
Back
Top