Is it possible to add a comma to a number inside a concatenate formula?

[Taylor_Felt]

I’d like to add a comma to a number value that I’m displaying in a detail w/ card view.

Any easy way to add a comma to the number after it says production deficit?

[Suvrutt_Gurjar · Accepted solution]

Please try wrapping the number column that denotes the energy quantity with TEXT()

CONCATENATE("Production Deficit: ", TEXT([Energy Value]) ,“KWh”)

[Energy Value] is assumed to be a number type column.

help.appsheet.com

TEXT()

Format as text

[Taylor_Felt]

Easy, thanks!