Format page numbering to be Page 1 of X
 

Hi ~

I would like to know the code to format page numbering in Excel so that it
will read "Page 1 of X" similar to the way you can format page numbering in
Word.

Thanks! Greeting from (finally) sunny San Francisco...

Format page numbering to be Page 1 of X
 

=ROMAN(C1)

This is the formula for roman numerals


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=530297

Format page numbering to be Page 1 of X
 

Click File/Page Setup, Select Headers/Footer

Page &[Page] Of &[Pages]


"Joan at UCSF" wrote:

Hi ~

I would like to know the code to format page numbering in Excel so that it
will read "Page 1 of X" similar to the way you can format page numbering in
Word.

Thanks! Greeting from (finally) sunny San Francisco...