Formating Cells in Excel

[killapiller]

I am trying creat a custom format in Excel and I need to know what character to use to specify that the digit could be either alpha or numeric. What I want the cells to do is when I enter either 4444444444 or 44444444A4 it is displayed as 444-44-44444 or 444-44-444A4. I know that the expression ###-##-##### will work for the first set, but I am at a loss for what to use in the second.

 

[SkipVought]

Hi,

Check out the format in Format/Cells-Number Tab-Special Select Phone or SSN

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[Cresby]

IF, ISNONTEXT, ISNUMBER and TEXT(cell,"blah blah")

would do it if you have data from another cell (maybe hidden)

eg If(ISNUMBER(cell),TEXT(cell,"format",IF(ISNONTEXT(cell),cell,TEXT(cell,"other format")))

of course you could format the cell during a WorkSheet_Change event and inspect every digit - I do it for drawing numbers like PL12345
then dump the result as text. As long as it does not look like a date and auto-completes ......... when I code to format the cell as text after every change (I hot-desk too much to muck about with other peoples' settings)

Don't ya just luuuuuuuuuuuuuuuv M$?