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

=ROMAN(C1)

This is the formula for roman numerals

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