VBA & Macro Problems

How to Create and Run the ConvertNumbersToText Macro in Word

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to learn how to create and execute a macro using the ActiveDocument.ConvertNumbersToText command to convert auto-numbered lists into plain text.

Product: Microsoft Word
Device & OS: not provided
Scenario: Converting dynamic automatic list numbers to static text using VBA.
Observed behavior: The user wants to run the conversion code either as a permanent reusable macro or as a one-time execution command.

Before you start

Ensure that the Developer tab is enabled in your word processor settings so you can access the Visual Basic Editor, and remember to save your work as a Macro-Enabled Document (.docm) if you intend to keep the code.

Solution 1Recommended

Create a Reusable ConvertNumbersToText VBA Macro

Best for users who need to frequently convert automatic numbers to text across multiple documents.

Creating a standard module allows you to save the macro permanently and run it anytime directly from your word processor's interface without having to retype the code.

Open the Visual Basic Editor

Press Alt + F11 on your keyboard to open the Visual Basic Editor window.

Insert a New Module

Click on 'Insert' in the top menu and select 'Module' to create a new standard module.

Add the Macro Code

Copy and paste the following code into the module window: Sub FixNumbers() ActiveDocument.ConvertNumbersToText End Sub

Run the Macro

Close the editor. You can now run the FixNumbers macro by pressing Alt + F8, selecting it from the list, and clicking 'Run'.

Mac Users: Mac users can follow similar steps by accessing the Visual Basic Editor through the Tools menu under Macros. Keyboard shortcuts may vary based on system settings.

Solution 2

Run the Command Once via the Immediate Window

Ideal if you only need to perform the text conversion once and do not want to save a permanent macro.

Write and Run VBA Macros

Use WPS Writer to Run VBA Macros and Manage Documents

WPS Writer supports VBA macros (in compatible premium or enterprise versions), allowing you to automate complex formatting tasks like converting auto-numbers to text exactly as you would in Microsoft Word.

1. Open your document in WPS: Launch WPS Writer and open the document containing the automatic numbers.
2. Access the Developer Tools: Navigate to the Developer tab on the ribbon and click on 'Visual Basic Editor', or simply press Alt + F11.
3. Run your Macro: Insert a new module and paste your ConvertNumbersToText code, or use the Immediate window to execute the VBA command instantly.

Full compatibility with Microsoft Word .doc and .docm file formatsBuilt-in Developer tools for creating, editing, and running VBA macrosLightweight architecture that performs smoothly on any hardwareFamiliar ribbon interface making the transition seamless and intuitive

microsoft office alternative - wps office

Frequently Asked Questions

What does ActiveDocument.ConvertNumbersToText actually do?

This command converts all dynamically generated list numbers (such as auto-bullet points and multi-level numbered lists) into static, editable plain text in your current document.

Why did my macro disappear after closing the document?

You likely saved the file as a standard Word Document (.docx). To keep VBA macros permanently, you must 'Save As' and select the Word Macro-Enabled Document (.docm) format.

How do I open the Immediate window if Ctrl+G doesn't work?

Inside the Visual Basic Editor, you can manually open the Immediate window by clicking 'View' in the top menu bar and selecting 'Immediate Window'.

Can I run this VBA macro on a Mac?

Yes, Mac users can run VBA macros. You will need to open the Visual Basic Editor via 'Tools' > 'Macro' > 'Visual Basic Editor', though keyboard shortcuts like Alt+F11 might need adjustment depending on your Apple keyboard settings.

Excel & Data Problems