| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
alphanumeric formating
This question is relating to book ISBN's. I want to find a way to create a
formatting so that when i enter "31062356x" , the excel will format it like "03106256x" "234" = "0000000234" "1256b" = 000001256B" basically a ten digit format tthat allows for a alpha char at the end Thanks for any input |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Conditional Formating | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Conditional formating using formulas | Excel Worksheet Functions | |||
| can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
| Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
