Roman numerals in Excel 2010


  1. Posts : 434
    Windows 7 Home Premium 64 Bit
       #1

    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 Computer


  2. Posts : 6,305
    Windows 7 Ultimate x64
       #2

    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 Computer


  3. Posts : 434
    Windows 7 Home Premium 64 Bit
    Thread Starter
       #3

    thanks, it worked
      My Computer


  4. Posts : 6,305
    Windows 7 Ultimate x64
       #4

    Glad I could help :)
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
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
All times are GMT -5. The time now is 20:40.
Find Us