What is the syntax for ROMAN in Excel?

The syntax for ROMAN is: =ROMAN(number, [form])

What is ROMAN used for in Excel?

ROMAN converts numbers (1-3999) to Roman numerals as text. Useful for document numbering (Chapter I, II, III), copyright years, clock faces, and formal document formatting. =ROMAN(2024) returns 'MMXXIV'.

What does the form parameter do in ROMAN?

Form controls how concise the Roman numeral is. 0 (default) = classic (MCMXCIX for 1999), 1-3 = increasingly concise forms, 4 = most simplified. Most people use 0 for standard Roman numerals.

Why can't ROMAN convert numbers above 3999?

Traditional Roman numerals don't have standard symbols for 5000 and above. The largest standard symbol is M (1000). While extended systems exist (using bars over letters), Excel's ROMAN only supports 1-3999.

Math & Trig

ROMAN Function in Excel

Converts an Arabic numeral to Roman numeral as text.

Syntax

=ROMAN(number, [form])

Arguments

number (required): Number to convert (1-3999)
form (optional): Type of Roman numeral (0-4)

Examples

=ROMAN(2024) - Convert to Roman - Result: MMXXIV

ROMAN in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#VALUE! if number > 3999

Use cases

Formatting
Document numbering
Display

Frequently asked questions

What is ROMAN used for in Excel? ROMAN converts numbers (1-3999) to Roman numerals as text. Useful for document numbering (Chapter I, II, III), copyright years, clock faces, and formal document formatting. =ROMAN(2024) returns 'MMXXIV'.
What does the form parameter do in ROMAN? Form controls how concise the Roman numeral is. 0 (default) = classic (MCMXCIX for 1999), 1-3 = increasingly concise forms, 4 = most simplified. Most people use 0 for standard Roman numerals.
Why can't ROMAN convert numbers above 3999? Traditional Roman numerals don't have standard symbols for 5000 and above. The largest standard symbol is M (1000). While extended systems exist (using bars over letters), Excel's ROMAN only supports 1-3999.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.