Formatting numbers

[Tom_automated]

I’ve got a column will all digits in the format of ##########. I would like to add a virtual column to reformat the numbers to ###-###-####. I am unclear as to what expression I need to input for the formula in the virtual column.

[Suvrutt_Gurjar · Accepted solution]

Please try

CONCATENATE(LEFT([InputNumber],3), “-”, MID([InputNumber],4,3), “-”, RIGHT([InputNumber],4))

Please take a look at

help.appsheet.com

MID()

Characters from text

help.appsheet.com

LEFT()

Left-most characters of text

help.appsheet.com

RIGHT()

Rightmost characters of text