Hi:
I need each cell to have 4 digits. For example, Cell A1 should have 4 digits
If number of Cell A1 digits < 4, add a zero to the front of the digits, otherwise leave alone.
So, if A1 = 292 would become 0292
Also, I guess if A1 = 92, it should become 0092
Thanks!
Charlie
I need each cell to have 4 digits. For example, Cell A1 should have 4 digits
If number of Cell A1 digits < 4, add a zero to the front of the digits, otherwise leave alone.
So, if A1 = 292 would become 0292
Also, I guess if A1 = 92, it should become 0092
Thanks!
Charlie