Type your search here:
Search
i.e.: skype, chrome, uTorrent

Converting Roman numeral Text to Numbers in Excel

 

Excel is a great tool to handle all sorts of numbers. But what happens if your worksheet includes Roman numeral text? Should you toss it all away and start anew, or is there an easier way to resolve this problem?

Luckily enough, with PowerUps' pwrARABIC function you can easily convert Roman numeral text into regular numbers.

pwrARABIC – making sense of Roman numeral text

In order to use the pwrARABIC function, click the 'PowerUps' option from the main tool bar:

 

 

Converting Numbers via Excel

 

Then, select the 'PowerUps Functions' option:

 

 

Converting text to numbers

 

Then, select the 'PowerUps' option. From this new menu, select the pwrARABIC function:

 

 

How to convert text to numbers in Excel

 

Once you've selected the pwrARABIC function, the function's interface window will open, asking you to choose the text to be converted. Now, you have two options. The first is to directly type in the Roman numerals you wish to have converted:

 

 

 

And have the result shown as the value of the chosen cell:

 

 

 

Or, you can choose a target cell. This means the function will convert this cell's content, which is in Roman numeral text, into regular numbers:

 

 

Converting text into numbers

 

And, you're done! Now you can handle Roman numeral text in your worksheets with ease and make the most out of your database!

Good luck!

 

Astro Newsletter

Enter your email address
I'd like to hear about cool new stuff
I’d also like to receive free games, demos and other fun offers
Subscribe
We will respect your privacy
Our monthly Newsletter will take you to the moon...
Well, maybe not, but you will discover some great new programs you can get and do amazing stuff with, and it will keep you up to date with all the hottest stuff. It is easy to unsubscribe, so why not give it a try?