View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

Unfortunately, I think the best way for you to do this is to enter it as
text. (put a hyphen before your entry)

"kdw" wrote:

Is there a way to save this format type so I can use it in another workbook?
The custom format only stays in the workbook it was created in.

Also, how do I create a format for something like 12-34-5F or 12-34-56?
00-00-00 works if all digits but won't work in the first example. @@-@@-@@
just repeats everything nor does @-@-@ work.

Thanks!