On Thu, 7 Nov 2013 16:49:51 +0100, Claus Busch wrote:


both suggestions work. But you have to modify them:
Formula for value in A1:
=TEXT(A1,"00000-0000-0000-00")
or
Number / Format / Custom / Type: 00000-0000-0000-00


Regards
Claus B.

Oh, these poor aging eyes. Thanks for picking up the extra "x" I missed.
Hopefully, that is what Sarah noted when she wrote that neither worked.