| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format alphanumeric field in Excel
I'm trying to format a text column in Excel to include dashes, but
cannot get this to work for a text field. For example, if i have an account number that includes numbers and letters, I would like anyone using the spreadsheet to type the account number, but have the cell automatically add the dashes (567HA-4B). I don't see any way to do this if the field contains non-numeric characters. Can anyone help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO YOU COUNT ALPHA CHARACTERS IN AN ALPHANUMERIC FIELD | Excel Discussion (Misc queries) | |||
| Function to find 'n'th largest alphanumeric field (like "Large") | Excel Worksheet Functions | |||
| Custom Alphanumeric Format | Excel Discussion (Misc queries) | |||
| Extract only numbers from an alphanumeric field in Excel? | Excel Discussion (Misc queries) | |||
| how to format alphanumeric cells as numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
