Add leading zeros to text value

[conorsgaffney]

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!