Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Returns for store credit only.

aus+uk / uk.comp.sys.mac / Re: Pages, insert table, then number format?

SubjectAuthor
* Pages, insert table, then number format?Alan Lee
+* Re: Pages, insert table, then number format?Alan B
|`* Re: Pages, insert table, then number format?Graham J
| `* Re: Pages, insert table, then number format?Alan B
|  `* Re: Pages, insert table, then number format?Alan B
|   `* Re: Pages, insert table, then number format?Chris Ridd
|    `- Re: Pages, insert table, then number format?Alan B
+- Re: Pages, insert table, then number format?Alan B
`* Re: Pages, insert table, then number format?WolfFan
 `- Re: Pages, insert table, then number format?Alan B

1
Pages, insert table, then number format?

<um3bj1$1fj1h$1@dont-email.me>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18835&group=uk.comp.sys.mac#18835

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!rocksolid2!news.neodome.net!news.mixmin.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: ala...@darkroom.plus.com (Alan Lee)
Newsgroups: uk.comp.sys.mac
Subject: Pages, insert table, then number format?
Date: Fri, 22 Dec 2023 06:50:09 +0000
Organization: A noiseless patient Spider
Lines: 10
Message-ID: <um3bj1$1fj1h$1@dont-email.me>
Reply-To: alan@darkroom.+.com
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Fri, 22 Dec 2023 06:50:09 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="f6ed999d28343551c52fbc4d80694517";
logging-data="1559601"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Kxcnt7Z8DhcZiPAC/gv3R"
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:zfU0nsQE4+2qFEjZv+nnQNPPL6k=
Content-Language: en-GB
 by: Alan Lee - Fri, 22 Dec 2023 06:50 UTC

Doing a document last night in pages, I had to insert a table with some
figures.
One column was numbered 0100, 0101,0102 etc. When put in, it kept
reverting to 100,101,102..., so to get it finished I had to use the
letter O, so, O100,O102..
How can I get it to stay with the leading 0?
Thanks
Alan.
--
Remove the '+' and replace with 'plus' to reply by email

Re: Pages, insert table, then number format?

<um3dgh$1frnd$1@alanrichardbarker.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18836&group=uk.comp.sys.mac#18836

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!alanrichardbarker.eternal-september.org!.POSTED!not-for-mail
From: alanrich...@gmail.com.invalid (Alan B)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Fri, 22 Dec 2023 07:22:58 -0000 (UTC)
Organization: Grumpy Old Men
Lines: 13
Message-ID: <um3dgh$1frnd$1@alanrichardbarker.eternal-september.org>
References: <um3bj1$1fj1h$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Fri, 22 Dec 2023 07:22:58 -0000 (UTC)
Injection-Info: alanrichardbarker.eternal-september.org; posting-host="65d973eac7609386df4d3677109e86cc";
logging-data="1568493"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19cZ8XfHoXCEDo4oUHnOjkkn3FDlmao5iyj4nJ3l8ibyw=="
User-Agent: NewsTap/5.5 (iPhone/iPod Touch)
Cancel-Lock: sha1:cKh0z7ODsIlUwuN/c8lm8EmdH6c=
sha1:ypm+F9V4vFJECcuFcPpQvzq5E3s=
X-Face: nG6>hdjT^mn!;GSJ^^\ZQOl<Y6ji0*21Sj'u?{'0H""UaDnLW|{</uR5Zkg0\93OsFI.LLS |,nz@w%Vezf1l7MmVVy/J+Z=Dl#quuPgB5)T2awRzA]X\2Sd(RZbxg{3{!mkZr%@@x'[U&VxyY4]sR 0Cwoj."gM#,0AR}|Lx[bvku-1o<yHzB.M`yRkH(,?Ed3&33O@_#B-+<g[3:X45}X)<NZfI+R"2rL3( w6edB|\DO7wks0SKvSp!tC3nmcONA8x
X-No-Archive: Yes
 by: Alan B - Fri, 22 Dec 2023 07:22 UTC

Alan Lee <alan@darkroom.plus.com> wrote:
> Doing a document last night in pages, I had to insert a table with some
> figures.
> One column was numbered 0100, 0101,0102 etc. When put in, it kept
> reverting to 100,101,102..., so to get it finished I had to use the
> letter O, so, O100,O102..
> How can I get it to stay with the leading 0?

Try placing a single quote character in front of them, eg ‘0100
The ‘ should not be visible when viewing the document.

--
Cheers, Alan

Re: Pages, insert table, then number format?

<um3i2c$1gf8i$1@dont-email.me>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18838&group=uk.comp.sys.mac#18838

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: nob...@nowhere.co.uk (Graham J)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Fri, 22 Dec 2023 08:40:21 +0000
Organization: A noiseless patient Spider
Lines: 20
Message-ID: <um3i2c$1gf8i$1@dont-email.me>
References: <um3bj1$1fj1h$1@dont-email.me>
<um3dgh$1frnd$1@alanrichardbarker.eternal-september.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Fri, 22 Dec 2023 08:40:44 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="32e7ea65dfcf3cacd1e9a412e0e9ae52";
logging-data="1588498"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/ToqH3Kwkw2uQ4kVoGoVgI"
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:91.0) Gecko/20100101
Firefox/91.0 SeaMonkey/2.53.18
Cancel-Lock: sha1:jGDijraIsZWXxGG6lsx7LV3UmDo=
X-Antivirus: AVG (VPS 231221-4, 21/12/2023), Outbound message
In-Reply-To: <um3dgh$1frnd$1@alanrichardbarker.eternal-september.org>
X-Antivirus-Status: Clean
 by: Graham J - Fri, 22 Dec 2023 08:40 UTC

Alan B wrote:
> Alan Lee <alan@darkroom.plus.com> wrote:
>> Doing a document last night in pages, I had to insert a table with some
>> figures.
>> One column was numbered 0100, 0101,0102 etc. When put in, it kept
>> reverting to 100,101,102..., so to get it finished I had to use the
>> letter O, so, O100,O102..
>> How can I get it to stay with the leading 0?
>
> Try placing a single quote character in front of them, eg ‘0100
> The ‘ should not be visible when viewing the document.
>

It may depend on whether you want to do arithmetic with the contents of
that cell. If you prepend a single quote I think the following
characters are treated as a string of text, and any arithmetic will give
strange results.

--
Graham J

Re: Pages, insert table, then number format?

<um3iap$1gga4$1@alanrichardbarker.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18839&group=uk.comp.sys.mac#18839

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!rocksolid2!news.neodome.net!news.mixmin.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!alanrichardbarker.eternal-september.org!.POSTED!not-for-mail
From: alanrich...@gmail.com.invalid (Alan B)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Fri, 22 Dec 2023 08:45:13 -0000 (UTC)
Organization: Grumpy Old Men
Lines: 24
Message-ID: <um3iap$1gga4$1@alanrichardbarker.eternal-september.org>
References: <um3bj1$1fj1h$1@dont-email.me>
<um3dgh$1frnd$1@alanrichardbarker.eternal-september.org>
<um3i2c$1gf8i$1@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Fri, 22 Dec 2023 08:45:13 -0000 (UTC)
Injection-Info: alanrichardbarker.eternal-september.org; posting-host="5edc26b2e4a6910c09bc063cdd7eeb34";
logging-data="1589572"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+Kz5A/GDeEebYNUTQVKMJTOCQPO7gZ1SZnDlLb7KNtKw=="
User-Agent: NewsTap/5.5 (iPad)
Cancel-Lock: sha1:GCFb2hCAtqcgYNvmzUP7obX6g6E=
sha1:vZUdc1vHdPIAOsi5ZrkpprVOEPA=
X-No-Archive: Yes
X-Face: nG6>hdjT^mn!;GSJ^^\ZQOl<Y6ji0*21Sj'u?{'0H""UaDnLW|{</uR5Zkg0\93OsFI.LLS |,nz@w%Vezf1l7MmVVy/J+Z=Dl#quuPgB5)T2awRzA]X\2Sd(RZbxg{3{!mkZr%@@x'[U&VxyY4]sR 0Cwoj."gM#,0AR}|Lx[bvku-1o<yHzB.M`yRkH(,?Ed3&33O@_#B-+<g[3:X45}X)<NZfI+R"2rL3( w6edB|\DO7wks0SKvSp!tC3nmcONA8x
 by: Alan B - Fri, 22 Dec 2023 08:45 UTC

Graham J <nobody@nowhere.co.uk> wrote:
> Alan B wrote:
>> Alan Lee <alan@darkroom.plus.com> wrote:
>>> Doing a document last night in pages, I had to insert a table with some
>>> figures.
>>> One column was numbered 0100, 0101,0102 etc. When put in, it kept
>>> reverting to 100,101,102..., so to get it finished I had to use the
>>> letter O, so, O100,O102..
>>> How can I get it to stay with the leading 0?
>>
>> Try placing a single quote character in front of them, eg ‘0100
>> The ‘ should not be visible when viewing the document.
>>
>
> It may depend on whether you want to do arithmetic with the contents of
> that cell. If you prepend a single quote I think the following
> characters are treated as a string of text, and any arithmetic will give
> strange results.

Yes I realised that after posting my reply. I’m still trying to think of a
workaround - do you have one?

--
Cheers, Alan

Re: Pages, insert table, then number format?

<um3n50$1h7pv$1@alanrichardbarker.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18840&group=uk.comp.sys.mac#18840

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!alanrichardbarker.eternal-september.org!.POSTED!not-for-mail
From: alanrich...@gmail.com.invalid (Alan B)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Fri, 22 Dec 2023 10:07:28 -0000 (UTC)
Organization: Grumpy Old Men
Lines: 29
Message-ID: <um3n50$1h7pv$1@alanrichardbarker.eternal-september.org>
References: <um3bj1$1fj1h$1@dont-email.me> <um3dgh$1frnd$1@alanrichardbarker.eternal-september.org> <um3i2c$1gf8i$1@dont-email.me> <um3iap$1gga4$1@alanrichardbarker.eternal-september.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=fixed
Content-Transfer-Encoding: 8bit
Injection-Date: Fri, 22 Dec 2023 10:07:28 -0000 (UTC)
Injection-Info: alanrichardbarker.eternal-september.org; posting-host="6b9f33c6a1d0f648db00a93afd74ec32";
logging-data="1613631"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/moMIFlIPnWCQtSBJGVid6FaVA9dPmb2l+BTnVRcqcMQ=="
User-Agent: Usenapp for MacOS
Cancel-Lock: sha1:LJTmOgWXnXCVgOu0QnRbZ5ctezw=
X-No-Archive: Yes
X-Usenapp: v1.27.2/d - Full License
X-Face: nG6>hdjT^mn!;GSJ^^\ZQOl<Y6ji0*21Sj'u?{'0H""UaDnLW|{</uR5Zkg0\93OsFI.LLS |,nz@w%Vezf1l7MmVVy/J+Z=Dl#quuPgB5)T2awRzA]X\2Sd(RZbxg{3{!mkZr%@@x'[U&VxyY4]sR 0Cwoj."gM#,0AR}|Lx[bvku-1o<yHzB.M`yRkH(,?Ed3&33O@_#B-+<g[3:X45}X)<NZfI+R"2rL3( w6edB|\DO7wks0SKvSp!tC3nmcONA8x
 by: Alan B - Fri, 22 Dec 2023 10:07 UTC

On 22 Dec 2023 at 08:45:13 GMT, "Alan B" <alanrichardbarker@gmail.com.invalid>
wrote:

> Graham J <nobody@nowhere.co.uk> wrote:
>> Alan B wrote:
>>> Alan Lee <alan@darkroom.plus.com> wrote:
>>>> Doing a document last night in pages, I had to insert a table with some
>>>> figures.
>>>> One column was numbered 0100, 0101,0102 etc. When put in, it kept
>>>> reverting to 100,101,102..., so to get it finished I had to use the
>>>> letter O, so, O100,O102..
>>>> How can I get it to stay with the leading 0?
>>>
>>> Try placing a single quote character in front of them, eg ‘0100
>>> The ‘ should not be visible when viewing the document.
>>>
>>
>> It may depend on whether you want to do arithmetic with the contents of
>> that cell. If you prepend a single quote I think the following
>> characters are treated as a string of text, and any arithmetic will give
>> strange results.
>
> Yes I realised that after posting my reply. I’m still trying to think of a
> workaround - do you have one?

Easy enough to do in Excel though using custom format!

--
Cheers, Alan

Re: Pages, insert table, then number format?

<um3tik$1i6pe$1@alanrichardbarker.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18841&group=uk.comp.sys.mac#18841

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!alanrichardbarker.eternal-september.org!.POSTED!not-for-mail
From: alanrich...@gmail.com.invalid (Alan B)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Fri, 22 Dec 2023 11:57:08 -0000 (UTC)
Organization: Grumpy Old Men
Lines: 14
Message-ID: <um3tik$1i6pe$1@alanrichardbarker.eternal-september.org>
References: <um3bj1$1fj1h$1@dont-email.me>
Injection-Date: Fri, 22 Dec 2023 11:57:08 -0000 (UTC)
Injection-Info: alanrichardbarker.eternal-september.org; posting-host="6b9f33c6a1d0f648db00a93afd74ec32";
logging-data="1645358"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19m+y1r4cbQjcuhoIv6hZLm2skmq/Gx8LJ0Bi1qhGaRZQ=="
User-Agent: slrn/pre1.0.4-9 (Darwin)
Cancel-Lock: sha1:oZiebzdTh3Nwk4Ld6Pbgr/JQ5AQ=
X-No-Archive: yes
X-Face: nG6>hdjT^mn!;GSJ^^\ZQOl<Y6ji0*21Sj'u?{'0H""UaDnLW|{</uR5Zkg0\93OsFI.L
LS|,nz@w%Vezf1l7MmVVy/J+Z=Dl#quuPgB5)T2awRzA]X\2Sd(RZbxg{3{!mkZr%@@x'[U&VxyY4
]sR0Cwoj."gM#,0AR}|Lx[bvku-1o<yHzB.M`yRkH(,?Ed3&33O@_#B-+<g[3:X45}X)<NZfI+R"2
rL3(w6edB|\DO7wks0SKvSp!tC3nmcONA8x
 by: Alan B - Fri, 22 Dec 2023 11:57 UTC

On 2023-12-22, Alan Lee <alan@darkroom.plus.com> wrote:
> Doing a document last night in pages, I had to insert a table with some
> figures.
> One column was numbered 0100, 0101,0102 etc. When put in, it kept
> reverting to 100,101,102..., so to get it finished I had to use the
> letter O, so, O100,O102..
> How can I get it to stay with the leading 0?

Re: my earlier replies, I think I've worked out how to do what you want in
Pages and Numbers. it involves a screen shot so if it's OK I'll email it to
you.

--
Cheers, Alan

Re: Pages, insert table, then number format?

<0001HW.2B35DDDF033DC8D870000926A38F@news.supernews.com>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18843&group=uk.comp.sys.mac#18843

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!1.us.feeder.erje.net!feeder.erje.net!border-1.nntp.ord.giganews.com!nntp.giganews.com!Xl.tags.giganews.com!local-2.nntp.ord.giganews.com!nntp.supernews.com!news.supernews.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 22 Dec 2023 15:08:15 +0000
Date: Fri, 22 Dec 2023 10:08:15 -0500
From: akwolf...@zoho.com (WolfFan)
Organization: the pack
Mime-Version: 1.0
User-Agent: Hogwasher/5.24
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Message-ID: <0001HW.2B35DDDF033DC8D870000926A38F@news.supernews.com>
Subject: Re: Pages, insert table, then number format?
Newsgroups: uk.comp.sys.mac
Reply-To: akwolffan@zoho.com
References: <um3bj1$1fj1h$1@dont-email.me>
Lines: 15
X-Trace: sv3-NejoQpRUQ3ySCQ4Yd9/lEmDpwXNe5Lx+wS4J78DHcoxRcH4VKRQoKmbnO8wevO9XFa6t5bVVpi2o1xd!HapHmZ+RWYYRvqzDzfNimIVAjYJAD0ZLs5ikcRu7UGYSRirJhWVW5PpVliLeCFQ8Hb+YccWDGKa8!dD51cq4ndqnLoms+mlLI6Q78
X-Complaints-To: www.supernews.com/docs/abuse.html
X-DMCA-Complaints-To: www.supernews.com/docs/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
 by: WolfFan - Fri, 22 Dec 2023 15:08 UTC

On Dec 22, 2023, Alan Lee wrote
(in article <um3bj1$1fj1h$1@dont-email.me>):

> Doing a document last night in pages, I had to insert a table with some
> figures.
> One column was numbered 0100, 0101,0102 etc. When put in, it kept
> reverting to 100,101,102..., so to get it finished I had to use the
> letter O, so, O100,O102..
> How can I get it to stay with the leading 0?
> Thanks
> Alan.

Build the table in Numbers, Excel, or other spreadsheet. Set custom number
format there. Import into Pages. The custom format should be retained.

Re: Pages, insert table, then number format?

<um49kg$1k3sn$1@alanrichardbarker.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18844&group=uk.comp.sys.mac#18844

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!news.1d4.us!usenet.goja.nl.eu.org!weretis.net!feeder8.news.weretis.net!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!alanrichardbarker.eternal-september.org!.POSTED!not-for-mail
From: alanrich...@gmail.com.invalid (Alan B)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Fri, 22 Dec 2023 15:22:56 -0000 (UTC)
Organization: Grumpy Old Men
Lines: 34
Message-ID: <um49kg$1k3sn$1@alanrichardbarker.eternal-september.org>
References: <um3bj1$1fj1h$1@dont-email.me> <0001HW.2B35DDDF033DC8D870000926A38F@news.supernews.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8; format=fixed
Content-Transfer-Encoding: 8bit
Injection-Date: Fri, 22 Dec 2023 15:22:56 -0000 (UTC)
Injection-Info: alanrichardbarker.eternal-september.org; posting-host="6b9f33c6a1d0f648db00a93afd74ec32";
logging-data="1707927"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+67Sv81/Qy5LAuNpYDkRiICoSIDieJfBh854AOmI4+sQ=="
User-Agent: Usenapp for MacOS
Cancel-Lock: sha1:Sq1hhsaJFXGz6Hm8PCfr9Xhzzfg=
X-Usenapp: v1.27.2/d - Full License
X-Face: nG6>hdjT^mn!;GSJ^^\ZQOl<Y6ji0*21Sj'u?{'0H""UaDnLW|{</uR5Zkg0\93OsFI.LLS |,nz@w%Vezf1l7MmVVy/J+Z=Dl#quuPgB5)T2awRzA]X\2Sd(RZbxg{3{!mkZr%@@x'[U&VxyY4]sR 0Cwoj."gM#,0AR}|Lx[bvku-1o<yHzB.M`yRkH(,?Ed3&33O@_#B-+<g[3:X45}X)<NZfI+R"2rL3( w6edB|\DO7wks0SKvSp!tC3nmcONA8x
X-No-Archive: Yes
 by: Alan B - Fri, 22 Dec 2023 15:22 UTC

On 22 Dec 2023 at 15:08:15 GMT, "WolfFan" <akwolffan@zoho.com> wrote:

> On Dec 22, 2023, Alan Lee wrote
> (in article <um3bj1$1fj1h$1@dont-email.me>):
>
>> Doing a document last night in pages, I had to insert a table with some
>> figures.
>> One column was numbered 0100, 0101,0102 etc. When put in, it kept
>> reverting to 100,101,102..., so to get it finished I had to use the
>> letter O, so, O100,O102..
>> How can I get it to stay with the leading 0?
>> Thanks
>> Alan.
>
> Build the table in Numbers, Excel, or other spreadsheet. Set custom number
> format there. Import into Pages. The custom format should be retained.

This is what I did in Pages ....

Select a relevant cell in the table
In the Formatting pane on the right hand side, select Cell
Select Create Custom Format from Data Format dropdown list
Optionally give it a name
Set type to Number (probably the default anyway)
Under Custom Format:
Tick Show Separator to remove , separator
Tick Show Zeros for Unused Digits
Ignore Add and Removed Digit options
Select Number of Digits to 4
Click OK to save
Apply custom form at to required cells

--
Cheers, Alan

Re: Pages, insert table, then number format?

<um7dmp$26m0p$2@dont-email.me>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18852&group=uk.comp.sys.mac#18852

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!paganini.bofh.team!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: chrisr...@mac.com (Chris Ridd)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Sat, 23 Dec 2023 19:50:49 +0000
Organization: A noiseless patient Spider
Lines: 14
Message-ID: <um7dmp$26m0p$2@dont-email.me>
References: <um3bj1$1fj1h$1@dont-email.me>
<um3dgh$1frnd$1@alanrichardbarker.eternal-september.org>
<um3i2c$1gf8i$1@dont-email.me>
<um3iap$1gga4$1@alanrichardbarker.eternal-september.org>
<um3n50$1h7pv$1@alanrichardbarker.eternal-september.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Date: Sat, 23 Dec 2023 19:50:50 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="6b684617756840ea53200e9c79e8778e";
logging-data="2316313"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+6RzdJ3wVYvtp/hoG74ZNdwkyx3PCf8FA="
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:xUSikFzBsE+8kYwa1g0XkA1gMMQ=
In-Reply-To: <um3n50$1h7pv$1@alanrichardbarker.eternal-september.org>
Content-Language: en-GB
 by: Chris Ridd - Sat, 23 Dec 2023 19:50 UTC

On 22/12/2023 10:07, Alan B wrote:
> On 22 Dec 2023 at 08:45:13 GMT, "Alan B" <alanrichardbarker@gmail.com.invalid>
> wrote:
>> Yes I realised that after posting my reply. I’m still trying to think of a
>> workaround - do you have one?
>
> Easy enough to do in Excel though using custom format!

Same in Pages/Numbers - create a custom number format with "Show zeros
for unused digits" set.

--
Chris

Re: Pages, insert table, then number format?

<um8k4h$2fobs$1@alanrichardbarker.eternal-september.org>

  copy mid

https://www.novabbs.com/aus+uk/article-flat.php?id=18855&group=uk.comp.sys.mac#18855

  copy link   Newsgroups: uk.comp.sys.mac
Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!alanrichardbarker.eternal-september.org!.POSTED!not-for-mail
From: alanrich...@gmail.com.invalid (Alan B)
Newsgroups: uk.comp.sys.mac
Subject: Re: Pages, insert table, then number format?
Date: Sun, 24 Dec 2023 06:46:41 -0000 (UTC)
Organization: Grumpy Old Men
Lines: 20
Message-ID: <um8k4h$2fobs$1@alanrichardbarker.eternal-september.org>
References: <um3bj1$1fj1h$1@dont-email.me>
<um3dgh$1frnd$1@alanrichardbarker.eternal-september.org>
<um3i2c$1gf8i$1@dont-email.me>
<um3iap$1gga4$1@alanrichardbarker.eternal-september.org>
<um3n50$1h7pv$1@alanrichardbarker.eternal-september.org>
<um7dmp$26m0p$2@dont-email.me>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Sun, 24 Dec 2023 06:46:41 -0000 (UTC)
Injection-Info: alanrichardbarker.eternal-september.org; posting-host="e48c336da36d0c6db06218f4759f03b3";
logging-data="2613628"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/PyqEuW1d1U7Ud/SnqGW3jptO/e7jVjW8Re7zl+IBzXg=="
User-Agent: NewsTap/5.5 (iPhone/iPod Touch)
Cancel-Lock: sha1:nYQVfMYEnAYYdq1gGduUTISmM28=
sha1:IgkYkkQ8/znF76WjTyCQjv8RRKg=
X-No-Archive: Yes
X-Face: nG6>hdjT^mn!;GSJ^^\ZQOl<Y6ji0*21Sj'u?{'0H""UaDnLW|{</uR5Zkg0\93OsFI.LLS |,nz@w%Vezf1l7MmVVy/J+Z=Dl#quuPgB5)T2awRzA]X\2Sd(RZbxg{3{!mkZr%@@x'[U&VxyY4]sR 0Cwoj."gM#,0AR}|Lx[bvku-1o<yHzB.M`yRkH(,?Ed3&33O@_#B-+<g[3:X45}X)<NZfI+R"2rL3( w6edB|\DO7wks0SKvSp!tC3nmcONA8x
 by: Alan B - Sun, 24 Dec 2023 06:46 UTC

Chris Ridd <chrisridd@mac.com> wrote:
> On 22/12/2023 10:07, Alan B wrote:
>> On 22 Dec 2023 at 08:45:13 GMT, "Alan B" <alanrichardbarker@gmail.com.invalid>
>> wrote:
>>> Yes I realised that after posting my reply. I’m still trying to think of a
>>> workaround - do you have one?
>>
>> Easy enough to do in Excel though using custom format!
>
> Same in Pages/Numbers - create a custom number format with "Show zeros
> for unused digits" set.
>

I worked that out eventually (see my later reply) but only using the macOS
version. No joy in setting it up with the iOS and iPadOS versions although
they recognise the custom number format setup in my macOS created test
file. Is that feature only available in the macOS version?

--
Cheers, Alan

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor