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

  • Thread starter Thread starter Forms document
  • Start date Start date
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?
 
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.
 
You must log in or register to reply here.

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

Microsoft Excel - Looking up values from a range by selection by scroll of arrow keys. 1
Custom Number Format for text 8
Numbers change in cell even when formatted as text 4
Excel Conditional Formatting 1
For Joey2004 et al. From OP: Re Appending Question 3
Conditional formatting in Excel 2010 2
Remove date format? 3
Entering a Text Symbol ? 2

Back
Top