Maintain leading zeroes without re-typing anything

[Battletoads]

I have a column of numbers, mostly single digit, that I need to turn onto all 3 digit numbers with leading zeroes (i.e. D1 contains "4" and I need E1 to contain "004", D2 has 20 so E2 should have 020). I know I can just format the cells as text and type in "004" and it will stay but I don't want to have to re-type everything. I highlighted all of my D column (with the single digit numbers) and went to format cells -> custom -> and typed in 000 to make everything 3 digits with zeroes but that leaves the cell format as "Special" and I need it to be "text" format. I feel like i'm totally missing something obvious here.

Thanks in advance

[Fluff13]

In E1
=TEXT(D1,"000")

[Battletoads]

In E1
=TEXT(D1,"000")

Worked perfectly, I added an extra step in pasting values into a separate column and formatting that as text but thanks for pointing me in the right direction

[Fluff13]

Glad to help & thanks for the feedback