Quick Navigation

ROMAN Function

Excel 2007+

Summary

The Excel ROMAN function converts Arabic numerals into Roman numerals as text output. It supports multiple formatting styles from traditional classic Roman notation to modern simplified versions, making it perfect for creating elegant numbering in reports, titles, and historical documents.

Syntax

ROMAN(number, [form])

Parameters

Parameter	Type	Required	Description
number	`Number`	Yes	The Arabic numeral (1-3999) you want to convert to Roman numerals
form	`Number`	No	Optional number specifying Roman numeral style (0-4, TRUE/FALSE)

Using the ROMAN Function

The ROMAN function transforms standard numbers into classical Roman numerals, adding a touch of elegance to Excel spreadsheets. Use it for document numbering, historical references, event timelines, or any situation where Roman numerals create visual appeal.

Common ROMAN Examples

Classic Roman Numeral (Default Style)

=ROMAN(499,0)

Displays 499 in traditional Roman numerals (CDXCIX) - the classic style used in ancient Rome.

Simplified Modern Style

=ROMAN(499,4)

Shows 499 as ID - the most concise simplified format for modern use.

Gradual Conciseness Progression

=ROMAN(499,1)

Returns LDVLIV - demonstrates the progression from classic to more concise formats.

Using Boolean Values

=ROMAN(2025,TRUE)

TRUE forces classic Roman numeral style regardless of the default.

Frequently Asked Questions

ROMAN function accepts numbers from 1 to 3999. Numbers above 3999 return #VALUE! error.

Form determines Roman numeral style: 0/TRUE=Classic, 1-3=Increasingly concise, 4/FALSE=Simplified.

Roman numerals are returned as text to preserve formatting and prevent Excel from treating them as numeric values.

Common Errors and Solutions

#VALUE! error

Cause: Number is negative, zero, or greater than 3999

Solution: Use only positive integers from 1 to 3999

Unexpected Roman numeral format

Cause: Form parameter outside valid range (0-4)

Solution: Use form values 0,1,2,3,4 or TRUE/FALSE only

Notes

ROMAN is available in Excel 2007 and later versions
Classic style (form=0) matches traditional Roman numerals
Simplified style (form=4) uses modern conventions like ID for 499
Results are always returned as text format
Perfect for copyright pages, movie credits, and outline numbering

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in: Excel 2003 and earlier

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+