Need help with a formula...
 

I need a formula that will allow a set of numbers to go from this:

xxxxxxxxxxxxxxx

to this:

xxxxx-xxxx-xxxx-xx


Every formula I've come across will only let me add three hyphens to a set of numbers, where as, I need to add four. I really don't want to have to do this manually. The hyphens in the example are placed where I actually need them to be.

Can anyone help?!

Need help with a formula...
 

On Wed, 6 Nov 2013 21:49:29 +0000, SarahAshlee wrote:


I need a formula that will allow a set of numbers to go from this:

xxxxxxxxxxxxxxx

to this:

xxxxx-xxxx-xxxx-xx


Every formula I've come across will only let me add three hyphens to a
set of numbers, where as, I need to add four. I really don't want to
have to do this manually. The hyphens in the example are placed where I
actually need them to be.

Can anyone help?!

If your number is in A1:

=TEXT(A1,"0000-0000-0000-00")

Or you can just custom format the cell using that code:

Number / Format / Custom / Type: 0000-0000-0000-00

Neither of those options worked.

Need help with a formula...
 

Hi Sarah,

Am Thu, 7 Nov 2013 14:32:22 +0000 schrieb SarahAshlee:

Neither of those options worked.

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Need help with a formula...
 

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.

Need help with a formula...
 

Hi Ron,

Am Fri, 08 Nov 2013 06:39:06 -0500 schrieb Ron Rosenfeld:

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.

not at all. I also need glasses ;-)


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2