This is a formatting issue. Basically, I would like to get all the numbers I enter into a column become 4 digits in the other column ("output column"), with 0's in front as applicable.
E.g. when I enter 16, I want the output cell to be
0016. What formula can I use for this?