formatted to place dashes within numbers formatted as text

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I convert numbers formatted as text back to numbers? 2
Convert numbers stored as text to numbers 2
convert large text to large number 5
Insert formatted text 0
How to copy and paste row as a text within workbook including numbers 5
quote within quote 3
to hide the arrow for numbers as text 2
Converting Numbers to Text properly 1

Top