Format-Code for columns with numbers

[Massreader]

Hello,

I want to create two individual columns, but I just can't handle the format for numbers.

One column should show numbers with a decimal comma (e.g. 4,5). I would choose floating point as the column type.

The second column should represent integers with a point separating the thousands.

What do I have to enter as the format code in each case to get the desired display?

Many thanks in advance for any help!

[theducks]

Right click that columns header: Edit custom column: (see image)

This uses Python formatting rules (link is in the dialog box)

[Comfy.n]

Originally Posted by Massreader

The second column should represent integers with a point separating the thousands.

for that one I've found {0:n} to work fine, I just tested it.

[Comfy.n]

Originally Posted by Massreader

One column should show numbers with a decimal comma (e.g. 4,5). I would choose floating point as the column type.

{:n} seems to work! (but I would wait for more experienced members' advice)

And I think you need to be using a compatible locale, I mean, the Calibre UI language, such as German, seems relevant in order to allow manual inputs with the comma instead of dot/point. If you have English as the Calibre UI language, you can insert manually 4 point 5 (not 4 comma 5), but in Book Details that number will still show as 4,5.

According to https://docs.python.org/3/library/st...-string-syntax :

'n' - Number. This is the same as 'g', except that it uses the current locale setting to insert the appropriate number separator characters.