Results 1 to 3 of 3
  1. #1
    liner
    Guest

    Roman Page Number (Excel 2003, SP2)

    Is it possible to put a page number in a header.............with roman numerals? Otherwise I will have to import the spreadsheet into Word, and then proceed. As the spreadsheet is large, it will make Word rather unwieldy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Roman Page Number (Excel 2003, SP2)

    No, Excel doesn't have the choice of number formats that is available in Word, there is no support for Roman numerals in the page number.

    It does have the ROMAN worksheet function though, perhaps you could enter a formula such as =ROMAN(13) in a cell at the top of page 13 etc. But it would be a manual process.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Roman Page Number (Excel 2003, SP2)

    You might checkout the code at ExcelTips: Roman Numerals for Page Numbers

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •