Convert number to roman number in Excel and Google Sheets

=ROMAN(A2)

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert number to roman number in Excel

How to convert numbers to roman numbers in Excel?
Convert number to roman number in Excel

CONVERT NUMBER TO ROMAN NUMBER — EXCEL FORMULA AND EXAMPLE

=ROMAN(A2)

  • A2 = data cell

Convert number to roman number in Google Sheets

How to convert numbers to roman numbers in Google Sheets?
Convert number to roman number in Google Sheets

CONVERT NUMBER TO ROMAN NUMBER — GOOGLE SHEETS FORMULA AND EXAMPLE

=ROMAN(A2)

  • A2 = data cell