The column is imported data,,, already containing number values. Thank you.
T tim m Jul 19, 2006 #2 You could try this formula and see if it is what you want. (this assumes your data starts in A1) =LEFT(A1,2)&"-"&RIGHT(A1,LEN(A1)-2)
You could try this formula and see if it is what you want. (this assumes your data starts in A1) =LEFT(A1,2)&"-"&RIGHT(A1,LEN(A1)-2)
