• Registered: 2022-09-13
  • Posts: 20

Topic: How do you Format a Column in the Table Tool

How does one format columns within a Table in Page Plus X7?

I’ve tried ‘right-clicking’ columns, looking at the Manual & the Help tab, but still cannot find the answer. Must admit that whilst I annually use the Calendar Tool, I rarely, if ever, the Table Tool. Hence my issue.

In this case quite basic. In column ‘A’, I want the first nine numbers in this column to have a ‘0’ before the1,2,3 etc. In column ‘C’, I want to get rid of the last ‘00’. This column represents the time, in minutes and seconds.   

I have also looked on Youtube but cannot find a Tutorial on using the Table Tool.

George

PS - Hopefully there should be a screenshot attached



https://i.postimg.cc/hQ7Nkyrq/Page-Plus.jpg

2 Reply by GB (edited by GB 2023-03-29 01:00:28)

  • GB
  • GB
  • Member
  • Offline
  • Registered: 2022-01-22
  • Posts: 351

Re: How do you Format a Column in the Table Tool

I do not think you can have a leading zero in number formatting, but the time format is available
https://i.postimg.cc/YL1K3mF1/Publication1.jpg
You can have a leading zero if you enter the number as text. To do this just add ' before the number, eg '01.

  • Registered: 2022-09-13
  • Posts: 20

Re: How do you Format a Column in the Table Tool

Thankyou. Continual experimenting has finally got my time column sorted, although more by luck than judgement methinks.

However whilst looking at your reply image and then looking at ‘Help’, I still cannot see how one gets to the screen that you have shown to be able to edit. I think I am still in the Excel mindsight where one just does a right click on a column and then can change the format.

All this though has also made me wonder whether there is actually any subtle difference between all the, what looks like nearly 50 tables one can select? Is it just cosmetic? Apart from the Calendar Tool I have not, up to now, needed to look at these Tools so am curious. 


https://i.postimg.cc/z3v4SPZB/PP-02.jpg

4 Reply by GB (edited by GB 2023-03-29 20:59:56)

  • GB
  • GB
  • Member
  • Offline
  • Registered: 2022-01-22
  • Posts: 351

Re: How do you Format a Column in the Table Tool

To get to the dialogue I showed, with the table selected, click the fx button on the top toolbar.

https://i.postimg.cc/VSGK49P4/noformat1.jpg

The Table toolbar will appear. Click the Number Format button on it.


https://i.postimg.cc/xkJmDLb6/noformat2.jpg

Can you do all your formatting in Excel, then Copy/Paste the whole Excel sheet into PagePlus? That will generate a PP Table automatically.

  • Registered: 2022-09-13
  • Posts: 20

Re: How do you Format a Column in the Table Tool

Thankyou for that. Have used PagePlus ages but not seen or had to use that icon before.

Still learning, thankyou.

George