Missing Leading Zeros

I am trying to display my data with zeroes at the front using a new column measure formula. The problem is the data is being displayed without the zeroes. Below are the images of the formula I am using and what is being displayed. I want the data to appear with the zeroes, like 0014, 0002, 0034. Instead, I am getting 14, 2, 34. Is there a way to display the data with the zeroes in front?

I have tried to change the data type to text, whole number, and decimal, but that doesn't do anything.