auto numbering in a table

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?
 
S

Stefan Blom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Paragraph Numbering Restarts After Sub Headings 2
convert auto numbered paragraph numbers to text 3
How do I turn off auto paragraph numbering but keep the para #s? 1
Auto Numbering Snafu 2
Word 2007: Auto-numbering, how to set a start number other than 1 2
how can I convert auto numbering in a table 1
sorting with auto numbering 3
Limiting ConvertNumbersToText to only certain parts of a document 3

Top