In ArcGIS you have the following window that allows you to visualize your numeric values in your attribute table in a diffrent manner. (Sorry the Image is in German)

enter image description here

In the example numeric values will be rounded to the 3rd decimal number and the alignment will be left. This does not change the data, it is simply represented differently in the attribute table. in ArcGIS you could also set the settings to show the data in scientific style or in fractions

I would love to do this in QGIS as well. To tell QGIS to represent the data with a max of 2 decimal numbers but actually use all decimal numbers when computing.

Is this somehow possible?

I'm using QGIS 3.4.13

  • which attribute table do you want to reformat? in the print layout you can apply any function you like (e.g. round() )
    – Ian Turton
    Commented Feb 11, 2020 at 11:51
  • I mean the attribute table in the project window
    – DGIS
    Commented Feb 11, 2020 at 12:39

1 Answer 1


You're able to display not the original column but a virtual field based on your original colum and then use something like the following :

  • 2
    hmm yes that would sort of work but its not nice to create a new field, eventhough its just virtual. There is no handier way?
    – DGIS
    Commented Feb 11, 2020 at 12:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.