Apply formula to the entire column

I'm trying to recode all the zip code from Column A into Column B with the formula:

=TEXT(A1,"00000")

Like this:

I want every cell in Column B to be transformed using the formula above. But I have over 40,000 rows, so it is impossible to drag down the formula and apply it to the entire Column B.

Is there a formula I could use to solve this problem?

I think it's a more recent feature, but it works for me:

Double clicking the square on the bottom right of the highlighted cell copies the formula of the highlighted cell.

Hope it helps.

It looks like some of the other answers have become outdated, but for me this worked:

1. Click on the cell with the text/formula to copy
2. Shift+Click on the last cell to copy to
3. Ctrl + Enter

(Note that this replaces text if the destination cells aren't empty)

I think you are in luck. Please try entering in B1:

=text(A1:A,"00000")

(very similar!) but before hitting Enter hit Ctrl+Shift+Enter.