Paste value with leading zero

[rahatadi (Aditya Rahatekar)]

@Benny_Chan

I would rather apply formula to entire column.

Fastest way to write an excel formula into an entire column

Refer above thread.