Format a decimal

Hi,

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

thanks

CONCATENATE([Decimal],“°C”)

2 Likes

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

image

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

2 Likes

yes, i do that but dont work

Send screenshot

1 Like

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 :slight_smile:

2 Likes

In a UX form, i have this :
image

in a UX detail, i have this :
image

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

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

1 Like

Thank you for your answers