Making a unique ID

[mikeazer]

Hi all, I am building an excel sheet for my real estate company. I am trying to create a unique ID for each customer. The ID is simply the building number, the floor number, and the apartment number.

If A1 is the building number, B1 is the floor number, and C1 is the apartment number, the ID should simply be =A1&B1&C1. The trick is that I need the ID to be 6 digits, so that the first 2 are the building, the next 2 are the apartment, and third 2 are the floor.

If I didn't do so I could mix up building(11), floor(1), apartment(1) with building(1), floor(11), apartment(1), both would be 1111.

I tried fixing it with number formats, 1 would look 01, but it doesn't work with "&"

 

[dan_l]

format the components as text?

 

[mikeazer]

I tried that .. it still doesn't work

 

[mikeazer]

Just in case my question wasn't clear.

I'm trying to make Building 1 (Cell A1), Floor 7 (Cell B1), and Apartment 13 (Cell C1), look like this 010713 in cell D1.

 

[Hui]

=text(A1,"00")&text(B1,"00")&text(C1,"00")

 

[oldchippy]

Hui...


You just pipped me to the post by 6 second with the same formula


=TEXT(A1,"00")&TEXT(B1,"00")&TEXT(C1,"00")

 

[mikeazer]

Hui and oldchippy .. Thank you soooo much .. This is exactly what I've been looking for.

 

[oldchippy]

Hi mike,


Thanks for the feedback, glad that we were able to lend a hand