custom formats (xxx-0000)

F

Frank Kabel

Hi
AFAIK this is not possible with formats. One workaround:
Use a helper column with a formula like
=LEFT(A1,3) & "-" & MID(A1,4,200)
-----Original Message-----
I'm trying to make a 3 letter, 4 number code such as
Click to expand...
PMP3010 to automatically add a dash between the number and
the letters. For example. I would like PMP3010 turn into
PMP-3010.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format custom number: C-0000-L 3
Difference between 2 dates&time(format 0000), and excludes weekend 1
Changing Telephone Number Format from (xxx) xxx-xxxx to xxx-xxx-xx 1
function result losing leading zeros 3
How to custom format a date 5
Count in a range of numbers 9
How do I change date format m/d/yyyy to mmddyyyy toremove the dash 2
Custom Formating Letters to Numbers while Displaying Letters 2

Top