Roman numerals in Excel 2010

T

theski232

New member
Member
VIP
Local time
4:43 AM
Messages
399
Location
Massachussetts
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 Computer My Computer

Computer Manufacturer/Model Number
Dell Studio 1749
OS
Windows 7 Home Premium 64 Bit
CPU
Intel i5 2.40GHz
Internet Speed
university ethernet sucks
Hi,

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

e.g.

="Hello"&ROMAN(13)

Capture.PNG

Hope it helps :)


OS
 

My Computer My Computer

Computer Manufacturer/Model Number
Compaq Desktop
OS
Windows 7 Ultimate x64
CPU
AMD Sempron Dual Core
Memory
3GB
Graphics Card(s)
NVIDIA GeForce 6150SE nForce 430
Screen Resolution
1024x768
Hard Drives
150GB Sata
thanks, it worked
 

My Computer My Computer

Computer Manufacturer/Model Number
Dell Studio 1749
OS
Windows 7 Home Premium 64 Bit
CPU
Intel i5 2.40GHz
Internet Speed
university ethernet sucks
Glad I could help :)
 

My Computer My Computer

Computer Manufacturer/Model Number
Compaq Desktop
OS
Windows 7 Ultimate x64
CPU
AMD Sempron Dual Core
Memory
3GB
Graphics Card(s)
NVIDIA GeForce 6150SE nForce 430
Screen Resolution
1024x768
Hard Drives
150GB Sata
You must log in or register to reply here.

Similar threads

MS Outlook 2010 won't print on HP LaserJet 400, prints on others
Replies
0
Views
7K
spapakons
spapakons
Solved How to show files in date order - not as straightforward as it sounds!
Replies
2
Views
2K
Firefox1701
F
Is it possible to read a text message sent to a Wingle
Replies
0
Views
498
Melita
Melita
Need authentication of Office 2016 I bought online. Any ideas?
Replies
0
Views
3K
OBE17
O
Solved Moving my C drive to another PC
Replies
4
Views
3K
Novice John
N
Back
Top