Hyphens

[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!

 

[Ken Wright]

Format / cells / custom / ###-###

 

[Don Guillett]

custom format.
000-000