Add leading zeros to text value

**conorsgaffney** · 10-20-2010, 02:48 PM

Hi All,

I've got a row of values like "Schaumburg 91" and "Niles 7". I'd like to render each value in the row to have leading zeros out to the hundreds place, so I would have "Schaumburg 091" and "Niles 007."

I've tried =TEXT(A1, "000") but to no avail.

Any suggestions?

Thanks!

**zbor** · 10-20-2010, 02:54 PM

Maybethis:

=LEFT(A1,FIND(" ",A1&" "))&" "&TEXT(MID(A1,FIND(" ",A1&" "),3),"000")

**conorsgaffney** · 10-20-2010, 02:59 PM

Yep, that definitely gives me the number with the correct amount of leading zeros. It removes the text, however. So I'm getting "091" from "Schaumburg 91"