Forum Discussion
Automatic NNNX formatting
Hi, i'm working with some data which requires to be setup in a specific way, containing an Address name + House number - it's seemingly a very simple issue, but i can't seem to solve it... The da...
One option is to change the number format of the house number column on Sheet A to Text, and to enter the house numbers with leading zeros.
The formula on Sheet B will then show the leading zeros too.
Another option is to leave Sheet A as it is, and change the formula on Sheet B to use the TEXT function:
=CONCATENATE(A2, TEXT(B2, "000"))
where A is the column with the street name and B is the column with the house number.