| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a field with numbers & text in MS2007
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I format a field with numbers & text in MS2007
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. "Forms document" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I format a field with numbers & text in MS2007
It has to be a formula, not custom formatting, but you don't need the
components in different columns. -- David Biddulph "Sheeloo" wrote in message ... 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. "Forms document" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Export Access to Excel text field with numbers | Excel Discussion (Misc queries) | |||
| How do I convert my old linked spreadsheets to MS2007? | Excel Worksheet Functions | |||
| Convert numbers from text format to number format | Excel Discussion (Misc queries) | |||
| ddd format to 'text' field | Excel Discussion (Misc queries) | |||
| converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Linear Mode
