Format a decimal

[CYRIL]

Hi,

I want to format a field (number/decimal) like this :
ex : 3,8 becomes 3,8°C

thanks

[1minManager]

CONCATENATE([Decimal],“°C”)

[CYRIL]

Hi,
that don’t work in a field “number” or “decimal” also in a field text, but my field is decimal.
and i don’t want creat e new field

[1minManager]

1minManager:

CONCATENATE([Decimal],“°C”)

CONCATENATE([BAC 1],“°C”)

[CYRIL]

yes, i do that but dont work

[1minManager]

Send screenshot

[CYRIL]

In a UX form, i have this :

in a UX detail, i have this :

[Aurelien]

In addition to what @1minManager told, I think you expect a formatting “in the cell”, such as you can do with Excel or Sheets ?
If so, that’s not possible.
The only pre-formatting allowed are with percent and price (we can pick currency).

For displaying after entrying value, than you need to create a Virtual Column with the @1minManager expression

[CYRIL]

is sheet
and I don’t want to create a new virtual column, there would be too many

[1minManager]

1minManager:

CONCATENATE([BAC 1],“°C”)

you could use this as the column name

But if you want it to say 2.9°C then this has to be in a text type column

[CYRIL]

Thank you for your answers