Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Format
Hi,
Done a bit of Googling but no luck so far... What I need to do is create a Custom cell format for the following: xxx##-######## Where the x's are any letter and the #'s are numbers. For example, if the user inputs: SHA11-1234 The Cell will automatically be formatted as: SHA11-00001234 Can this be done? Cheers, Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Cell Format Will Not Save Correctly | Excel Worksheet Functions | |||
Custom percent format needed | Excel Worksheet Functions | |||
Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |