Adding a % to an integer column.

ownedbycats · 11-01-2020, 12:01 AM

Aside from making an entirely new composite column, is there a way to add a percent sign to the end of any integers in a column?

I tried putting {0:%} but it led to....not the expected result

Click image for larger version

Name: 2020-11-01 01_24_27-Window.png
Views: 173
Size: 921 Bytes
ID: 183141

ownedbycats · 11-01-2020, 12:58 AM

I figured it out! I put {0}% in the format field and it worked.

dunhill · 11-01-2020, 12:55 PM

Self-questionnaire but useful for sharing. I was just going to answer you because I manage a library for a reading group that every month vote for genres and books, and I put that data into a Calibre library

11-01-2020, 12:01 AM	#1
ownedbycats Custom User Title Posts: 10,666 Karma: 74166147 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	Adding a % to an integer column. Aside from making an entirely new composite column, is there a way to add a percent sign to the end of any integers in a column? I tried putting {0:%} but it led to....not the expected result Last edited by ownedbycats; 11-01-2020 at 12:26 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Customize the positive and negative number format on an integer column	Sandwich	Library Management	5	10-13-2020 05:15 AM
Integer Column	Quetico	Reading and Management	0	07-09-2017 11:27 PM
[SOLVED] Remove value accidentally added to custom integer column	macnab69	Library Management	11	07-07-2013 07:58 AM
Method to set Date from user integer column	macnab69	Library Management	9	07-07-2013 07:52 AM
Rounding to nearest integer in Custom Column - Hijri Year	oelgamal	Calibre	2	03-28-2013 07:12 PM

11-01-2020, 12:58 AM	#2
ownedbycats Custom User Title Posts: 10,666 Karma: 74166147 Join Date: Oct 2018 Location: Canada Device: Kobo Libra H2O, formerly Aura HD	I figured it out! I put {0}% in the format field and it worked.

11-01-2020, 12:55 PM	#3
dunhill Guru Posts: 866 Karma: 409968 Join Date: Sep 2017 Location: Buenos Aires, Argentina Device: moon+ reader, kindle paperwhite	Self-questionnaire but useful for sharing. I was just going to answer you because I manage a library for a reading group that every month vote for genres and books, and I put that data into a Calibre library

Advert