Hi Team,
how can I add text to a value?
i have a column (numbers) where I only have numbers.
I want that text is added automatically like “mm”. so it would look like: 15mm
Pretty sure ther must be a formula to add text but I just can’t find it
please help
Dear @Cello_Chevy,
You might want to use the concatenate formula
3 Likes
Or Format()
, that I slightly prefer:
Format("{1}mm", [YourColumn])
2 Likes
Can this only be done with a helper column (ie. input column and formatted column)? I don’t see a way to have the format applied to the column in which you enter the new values, correct?
1 Like
Good point @joost_mineur: this “auto formatting” cannot take place in the same column as the input.
In Coda columns can be either data (input of different kind) or fomula (computed), not a mix.
but currency can, why not other?
1 Like
Thank you @Federico_Stefanato I was hoping it to take place in same column same as @Kristijan_Moser example with currency.
But thank you all for your quick replies much appricieted.
Because currency is a special native column type in Coda
1 Like