Forum Discussion
Custom formatting number
The part number in one table is 1087242231 but in another table it is 1087.242.231,
For forming a relationship between two tables, I will need the Part number in first table to look like 1087.242.231 similar ot that of the second table.
Can I please know the method to fomat it?
Thank You,
Rushi
Anonymous
Maybe you can create a new column
Column = LEFT('Table'[Column1],4)&"."&mid('Table'[Column1],5,3)&"."&RIGHT('Table'[Column1],3)
1 Reply
Anonymous
Maybe you can create a new column
Column = LEFT('Table'[Column1],4)&"."&mid('Table'[Column1],5,3)&"."&RIGHT('Table'[Column1],3)