Spelling Out Page Numbers

[Robert Gibson PWES]

Hi guys! So apparently, my client wants his page numbers spelled out in words. Not 1,2,...  but ONE, TWO .... 

I looked at the Section Manager of the Pages panel but there doesn't seem to be a native way of doing this. None of the formatting of the Page Number field options allows for what he wants. Is there a trick to this or do I have to manually add these numbers? I'm not looking forward to that as an option...

[GarryP]

I’m pretty sure that Publisher cannot do what you want.
However, someone might be able to come up with a clever alternative solution.

[carl123]

Data Merge.

[Robert Gibson PWES]

Data Merge .... okay I'll look into this. Thanks for the nudge!

1 minute ago, carl123 said:

Data Merge.

 

[Old Bruce]

Not Data Merge but a text file with the words written out on separate lines then that text file placed into the Page Number Text Frame which is linked to the next Page Number Text Frame.

Post Script: Tell your client that according to Old Bruce his readers will curse him/her for insisting on this.

[Robert Gibson PWES]

1 minute ago, Old Bruce said:

Not Data Merge but a text file with the words written out on separate lines then that text file placed into the Page Number Text Frame which is linked to the next Page Number Text Frame.

Post Script: Tell your client that according to Old Bruce his readers will curse him/her for insisting on this.

Well @Old Bruce ....  I'M cursing him already - that sounds like a LOT of work.

[Old Bruce]

1 minute ago, Robert Gibson PWES said:

I'M cursing him already

Show me a client you haven't cursed. Be honest now. [smiley face emoticon]

[joe_l]

20 minutes ago, Old Bruce said:

Tell your client that according to Old Bruce his readers will curse him/her for insisting on this.

When the finalized document has 123456789012345678901234567890 pages, the client maybe changes his mind.

[Robert Gibson PWES]

Just now, joe_l said:

When the finalized document has 123456789012345678901234567890 pages, the client maybe changes his mind.

Indeed LOL I'll mention it lol

[Old Bruce]

Is page 1234 

"One Thousand Two Hundred and Thirty-four"

or

"Twelve Hundred and Thirty-four"?

[thomaso]

29 minutes ago, Robert Gibson PWES said:

that sounds like a LOT of work

Who is expected to deliver the text contents
– Instead of manually typing all words of spelled numbers maybe this helps:

Convert numbers into words
Excel doesn’t have a default function that displays numbers as English words in a worksheet, but you can add this capability by pasting the following SpellNumber function code into a VBA (Visual Basic for Applications) module.

https://support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98

[carl123]

You can convert the numbers to words online

Lots of websites to do that

https://onlinenumbertools.com/convert-numbers-to-words

[thomaso]

7 minutes ago, Old Bruce said:

"One Thousand Two Hundred and Thirty-four"

Is it separate words in English? If yes, why the dash in thirty-four?
I'd expect them to be "onethousandtwohundredthirtyfour", looks more like a page number. 🤓

[thomaso]

6 minutes ago, carl123 said:

You can convert the numbers to words online

Lots of websites to do that

https://onlinenumbertools.com/convert-numbers-to-words

Great! Plus, without MS, a number generator first: https://textmechanic.com/text-tools/numeration-tools/generate-list-numbers/

[Alfred]

1 hour ago, thomaso said:

Is it separate words in English? If yes, why the dash in thirty-four?

Yes, it’s separate words, but when whole numbers between 0 and 99 are written in words they’re always either single (e.g. fourteen) or hyphenated (e.g. thirty-four).

1 hour ago, thomaso said:

I'd expect them to be "onethousandtwohundredthirtyfour", looks more like a page number. 🤓

Unlike German, English isn’t an agglutinative language, so we keep the words separate (e.g. „Zwetschgenkuchen“ is plum cake, not plumcake).

[firstdefence]

2 hours ago, Alfred said:

agglutinative

I had to look this word up and I'm still none the wiser, I'm still convinced Alfred typed this like Jimmy Hendricks played guitar

[Robert Gibson PWES]

On 6/9/2022 at 11:35 AM, thomaso said:

Great! Plus, without MS, a number generator first: https://textmechanic.com/text-tools/numeration-tools/generate-list-numbers/

On 6/9/2022 at 11:25 AM, carl123 said:

You can convert the numbers to words online

Lots of websites to do that

https://onlinenumbertools.com/convert-numbers-to-words

Ok thanks for those websites. I have the words for the page numbers. (Thankfully only 180 - sorry One Hundred and Eighty).

On 6/9/2022 at 10:35 AM, Old Bruce said:

Not Data Merge but a text file with the words written out on separate lines then that text file placed into the Page Number Text Frame which is linked to the next Page Number Text Frame.

Post Script: Tell your client that according to Old Bruce his readers will curse him/her for insisting on this.

 

@Old Brucedo I put the text frames that are linked into the Master Page? I tried it and my Publisher crashed. (I have everything backed up just in case this time;)

[thomaso]

52 minutes ago, Robert Gibson PWES said:

I put the text frames that are linked into the Master Page? I tried it and my Publisher crashed.

After what action does it crash? Can you show a video of putting text frames and crash?

If you already have created all pages just paste the text into the accordingly linked master frame on page one and the text will flow. – If you want the page numbers auto-generate the required pages then paste the text in this frame and Shift-Click the triangular text flow symbol. Text flow and auto-generation of pages work independently of master pages, means also without a master page.

[Robert Gibson PWES]

1 hour ago, thomaso said:

After what action does it crash? Can you show a video of putting text frames and crash?

If you already have created all pages just paste the text into the accordingly linked master frame on page one and the text will flow. – If you want the page numbers auto-generate the required pages then paste the text in this frame and Shift-Click the triangular text flow symbol. Text flow and auto-generation of pages work independently of master pages, means also without a master page.

 

Thank you for this. I will try again. It crashed when I tried to link the text boxes together in the master page. However, I'll see what happens this time.

[Robert Gibson PWES]

1 hour ago, thomaso said:

After what action does it crash? Can you show a video of putting text frames and crash?

If you already have created all pages just paste the text into the accordingly linked master frame on page one and the text will flow. – If you want the page numbers auto-generate the required pages then paste the text in this frame and Shift-Click the triangular text flow symbol. Text flow and auto-generation of pages work independently of master pages, means also without a master page.

 

Thank you for this. I will try again. It crashed when I tried to link the text boxes together in the master page. However, I'll see what happens this time.

 

 

It has worked! Thank you guys!