I have CSV contains 04, 05, 00234, etc in columns

I want to preserve format Leading Zeros in numbers.

I added '04, formated a text field still format is getting loss ad answer is 4

What can be done to preserve formatting in CSV?

Also is there is alternate way to use with VBA?