QGIS format_number with tailing zeros

Question

I am working in a attribute table trying to format my numbers, but want to keep ending zeros. I am using format_numbers("column",sig figs). For the most part, it is working, but for example row two in the picture below, I need to zero to show to have everything line up perfectly. I am working in QGIS 3.10.4.
Any suggestions on how to do this?

Mike Talbot · Accepted Answer

Sounds like you figured it out. For posterity, I would set up a separate string field and use the Attributes Form to automatically reformat the values from your numeric field:

Here is the result:

QGIS format_number with tailing zeros

One Answer

Add your own answers!

Ask a Question