Format page numbering to be Page 1 of X

[Joan at UCSF]

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...

 

[davesexcel]

=ROMAN(C1)

This is the formula for roman numeral

 

[JMB]

Click File/Page Setup, Select Headers/Footer

Page &[Page] Of &[Pages]