I bet bj meant the apostrophe ('), not the hyphen (-).



bj wrote:

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!

--

Dave Peterson