Hyphens

G

Gary

Trying to format a number of cells to accept a hyphen.
The cells will have 6 digits and they need to read 123-
456. Can cells be formatted where I can put in 6 digits
and it will automatically place in hyphen between
characters 3 and 4?

Thanks!
 

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

Using FIND to highlight text (with dashes) 4
LOOKUP function help 6
Multiple formats in one cell 1
DOCPROPERTY field switches and non-breaking hyphens and spaces 5
Macros to convert Data into date format and then plot in graph 7
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Text Extraction (parsing) 3
Remove data that preceeds a character 6

Top