Custom Formatting for Cells with Numbers and A Letter

How would I go about formating a cell which is made up of all numbers except for one character, which is a letter? I need it to look like this:

Please Login or Register  to view this content.

I have tried many things but nothing has worked and when I try:

Please Login or Register  to view this content.

It does not work. That is the closest I come to getting anything to work.

This field is entered in numerous times and it would not be efficient to enter a formula each time or do anything tricky. Does anyone know if this is possible?

Thanks :-)

Custom formatting is applied to numbers and since you have a letter, it won't work. It might be possible with VBA. What exactly are you entering? e.g. do you always enter the entire 15 characters and you just want excel to put in the dashes? or sometimes do you enter 14?

You could also enter it into 1 cell and have a formula in the next column which adds the dashes using LEFT, MID and/or RIGHT functions.

The one letter turns the entire thing into a text string, so custom "number formats" don't apply.

For some reason you can simply enter it as shown (with dashes) in the first cell and reference that cell in the other places that need to show the same value? What would be wrong with entering that way?

#-##-###-##-#A-#####
The formula answer, lets say you're entering in column B, this would be in Col C. In C2 (and dragged down)

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.