Is there any ways to make it so when you start typing, the numbers start from the left hand side of your custom format?
Basically I want to make a cell that has a job number, but I want it to be able to have a total of 5 changeable numbers.
I want the last one to be unnecessary, so I can make a job number that goes up above 99, but only shows itself after I have past that threshold.
IE.)
Custom Format is
00-00#
If I type 0101 it shows
01-01
which leaves the last value blank.
Bookmarks