From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,500 courses taught by industry experts.

How to covert ROMAN numberals

How to covert ROMAN numberals - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

How to covert ROMAN numberals

“

- Using Roman numerals is not that important 2 for most Excel users, but occasionally 3 you might want to use them. 4 And in column A, we've got some numbers. 5 Maybe some of these relate to years, 6 some of 'em are just code numbers, 7 We're not sure necessarily. 8 There is a function called Roman. 9 And as we apply it to these entries here 10 and complete the entry, 11 we do see this being displayed in Roman numerals. 12 I'll drag this down the column 13 and something will pop out immediately at you. 14 Doesn't work here. 15 This only works on values up to 3-9-9-9 16 3,999. 17 And although not critical, 18 you might want to display these in a Roman-type font. 19 So, and I've actually done this over in 20 column D already for these letters. 21 Here are the seven letters that we see as we work 22 with Roman numerals and their meaning to the right. 23 And although not truly necessary, 24 I will click on column B…

Contents