J
Jon
Strange! Needed to have a 10 digit number, some with zeros as place
holders, ie: 0092-1234-01.
Found a post from one of you that said just format under custom using
quotation marks ("-") where the dashes need to be placed.
Worked like a charm (THANKS!) except for one little glitch. On some
cells, I am required to place the cursor within the cell and double
click to get the dashes to appear. Wouldn't be a big deal except that
my list has 4,534 rows in that column, so double clicking in all is a
little unreasonable. What am I missing here? Anyone?
holders, ie: 0092-1234-01.
Found a post from one of you that said just format under custom using
quotation marks ("-") where the dashes need to be placed.
Worked like a charm (THANKS!) except for one little glitch. On some
cells, I am required to place the cursor within the cell and double
click to get the dashes to appear. Wouldn't be a big deal except that
my list has 4,534 rows in that column, so double clicking in all is a
little unreasonable. What am I missing here? Anyone?