Windows 7 Forums


Windows 7: Roman numerals in Excel 2010

04 Nov 2010   #1

Windows 7 Home Premium 64 Bit
Massachussetts
 
 
Roman numerals in Excel 2010

i know the =ROMAN(number) formula to get roman numerals, but what i have a problem with is getting text in the same cell as the roman numeral

My System SpecsSystem Spec

04 Nov 2010   #2

Windows 7 Ultimate x64
Milton Keynes, United Kingdom
 
 

Hi,

the whole cell, including text has to be a complete formula...

e.g.

="Hello"&ROMAN(13)

Roman numerals in Excel 2010-capture.png

Hope it helps


OS
My System SpecsSystem Spec
04 Nov 2010   #3

Windows 7 Home Premium 64 Bit
Massachussetts
 
 

thanks, it worked
My System SpecsSystem Spec
.


04 Nov 2010   #4

Windows 7 Ultimate x64
Milton Keynes, United Kingdom
 
 

Glad I could help
My System SpecsSystem Spec
Reply

 Roman numerals in Excel 2010 problems?



Thread Tools



Similar help and support threads for: Roman numerals in Excel 2010
Thread Forum
Solved Excel 2010 help Microsoft Office
excel 2010 Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Solved Excel 2010 Microsoft Office
microsoft excel 2010 Microsoft Office


All times are GMT -5. The time now is 03:00 AM.



Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd