How do you insert page number in the footer of an exported excel file using xml?

[Amegi18]

Hi,

I saved my excel file as xml and the part below would result to "1/2" (as in 1 of 2 pages) as page number in the footer.

<Footer x:Data="&P/&N"/>

I did that on my code but unfortunately, when exported, it literally and letter-per-letter displays : &P/&N

How do I fix that? Does anybody have another idea on how to insert page numbers?

Thanks,

 

[Sixthsense]

May be this...

For Current Page
&[Page]

For All Pages
&[Pages]