Insert Roman Numerals in Google Docs and Sheets

You can add Roman numerals in Google Docs as list markers or ordinary text, and in Google Sheets by converting numbers with a formula. The steps below cover both apps, including what to try when a numeral displays incorrectly.

What You’ll Need

• A Google account and access to Google Docs or Google Sheets in a web browser or their mobile apps.
• For Sheets, a number to convert and a cell where you want the Roman numeral to appear.
• For Docs, decide whether you need Roman numerals as list numbering or as text within a sentence or heading.

Step-by-Step

1. Choose the right method. Use Docs’ numbered-list controls when you are numbering an outline or list. Use plain text when you need a Roman numeral in a title, sentence, or standalone label. In Sheets, use the ROMAN function to convert an Arabic number, such as 14, into XIV.
2. Start a Roman-numeral list in Google Docs. Open the document and click where the list should begin. Select the arrow beside the numbered-list button in the toolbar, then look through the available numbering styles for a Roman-numeral format. Choose the style you want and type the first item. Press Enter to create the next item; Docs continues the numbering automatically.
3. Change an existing Docs list. Click a number or marker in the list to select its numbering format. Open the numbered-list style menu in the toolbar and choose a Roman-numeral option. If you only want to change one list level, make sure your cursor is on that level before selecting the style. Use Tab or the increase-indent control to create a nested level; use Shift+Tab or decrease indent to move back out.
4. Type a Roman numeral as ordinary text in Docs. Click where the characters should go and type them using capital letters: I, V, X, L, C, D, and M. For example, type Chapter IV or Section IX. This is plain text, not an automatically updating list marker. If you use lowercase Roman numerals, type i, ii, or iv directly.
5. Convert a number in Google Sheets. Select an empty cell where the result should appear. Enter =ROMAN(14) and press Enter. The cell displays XIV. Replace 14 with another whole number, or reference a cell containing the value, such as =ROMAN(A1). Keep the formula in a different cell from the input so it does not overwrite the number you are converting.
6. Choose a conversion style if needed. Sheets accepts an optional second argument called form, from 0 to 4. Form 0 (the default) produces the classic Roman-numeral form; higher values use progressively more compact forms. For example, =ROMAN(499,0) returns CDXCIX, while a compact form can use fewer characters. If you need standard, familiar notation, omit the second argument or use 0.
7. Fill the formula down a column. If you have a list of values in column A, put =ROMAN(A1) in the first result cell. Select that cell and drag its small fill handle down, or copy and paste the formula into the rows below. Sheets adjusts the row reference as it fills, converting each corresponding value.
8. Keep results as fixed text if required. A formula result changes when its source number changes. To preserve the current Roman numerals, copy the result cells, then use Edit > Paste special > Values only. The pasted cells contain text rather than formulas. In Docs, list markers remain connected to the list; to use a marker elsewhere, type the numeral as ordinary text.

Common Mistakes

• Expecting Docs to convert numbers automatically. Typing 4 does not turn it into IV. Choose a Roman-numbered list style or type IV yourself.
• Using a list marker where plain text is needed. Docs list numbering is managed as part of the list. It may restart or change as you edit list structure; type the numeral directly when it must be part of a fixed phrase.
• Entering a value Sheets cannot convert. ROMAN is intended for whole numbers from 1 through 3,999. Zero, negative numbers, decimals, and values above 3,999 do not produce a standard Roman-numeral result.
• Forgetting the equals sign or parentheses. In Sheets, enter a formula like =ROMAN(A1). Without the equals sign, Sheets treats the entry as text.
• Using a compact form by accident. A second argument from 1 to 4 changes the style. Leave it out for conventional notation, particularly for schoolwork, formal documents, or references that expect the standard form.

Tips

• Roman numerals use capital letters I, V, X, L, C, D, and M. The usual subtractive pairs include IV (4), IX (9), XL (40), XC (90), CD (400), and CM (900).
• Use Sheets when you need to convert many numbers or want results to update when the source values change. Use Docs list numbering when the numerals should advance automatically as you add or remove list items.
• Check the result against the context. Chapter headings often use uppercase numerals, while outline levels may use lowercase numerals; keep one style consistent throughout the document.
• If a document needs a fixed numeral, consider copying it as text rather than relying on a formula or automatically numbered list that might change later.

Troubleshooting

The Docs list uses ordinary numbers. Click a list marker and open the numbered-list style menu again. If the Roman option is not immediately visible, inspect the other available styles. If the list has mixed levels, select an item at the level you want to change before applying a style.

Docs keeps restarting the numbering. The items may be separate lists rather than one continuous list. Open the list options from a marker and look for a continue-numbering option. If you want a fresh Roman-numeral sequence, choose the restart option instead. Menu wording and placement can vary across devices.

Sheets shows an error or does not change the value. Check that the formula begins with =, the referenced cell contains a number, and the value is a whole number from 1 to 3,999. If the number is stored as text, re-enter it as a number or convert it before using ROMAN. Also check that the formula cell is not formatted or entered as plain text; change its format to Automatic or Number, then re-enter the formula.

The formula displays literally. The cell may be set to plain text, or the entry may begin with an apostrophe. Change the cell format, remove any leading apostrophe, and type the formula again. On mobile, tap the checkmark or equivalent confirmation control after editing.

Frequently Asked Questions

Can Google Docs automatically number a list with Roman numerals?
Yes. Choose a Roman-numeral style from the numbered-list menu, then press Enter between items to continue the sequence.

How do I write a Roman numeral in Google Sheets?
Use =ROMAN(number), such as =ROMAN(9), which returns IX. You can also refer to a cell, for example =ROMAN(A1).

Can I convert a whole column of numbers?
Yes. Put a formula such as =ROMAN(A1) beside the first number and fill it down. Each row converts the number in its corresponding source cell.

Why does ROMAN not accept zero?
Standard Roman numerals do not have a conventional symbol for zero. Sheets’ ROMAN function supports positive whole numbers from 1 through 3,999.

Can I change the Roman numerals to lowercase?
In Docs, type lowercase numerals as text where needed. In Sheets, the ROMAN function returns uppercase characters, so use a lowercase text function such as LOWER around the result if lowercase output is required.

Can Sheets convert numbers above 3,999?
The standard ROMAN function is limited to 3,999. For larger values, choose a notation convention that suits your task and enter or construct the result separately.

Related

• How to Choose the Best VPN for Peru
• Microsoft 365 Add-Ins Across Outlook, Word, Excel and Teams
• Delete Google Activity History on Your Computer