How do I format a field with numbers & text in MS2007

F

Forms document

How do I format a cell from B802412M07 to B-80241-2-M07. I know how to do it
with a formula but is there a way to just custom format the cell?
 
S

Sheeloo

You can custom format numbers but not alphabets

To convert 12345 go 12-345 use 00-000

To get what you want you will need to have alphabets and numbers in separte
columns and then join them.
 
D

David Biddulph

It has to be a formula, not custom formatting, but you don't need the
components in different columns.
 
Top