I need to format a column that may contain both Alpha and Numeric characters in it, but can't figure out exactly how to do it. The usual format for the information I'm entering is usually something like 901048-011480-4. Occasionally, the number will have alpha characters in it as it is a Hexadecimal number, i.e. 901048-G1H480-9. I know I can use ######-######-# to get the correct format for the number only entry, but is there a way I can make it format the same way regardless of if it is an alpha or a numeric character? Thanks.

Wayne