Number Formating
Hello Everyone,
I have thousands of numbers that will be fed into a spreadsheet
some of the numbers will be:
five digits - five digits (e.g. 22222-22222) note: that is a dash not a
minus
some will be:
4 digits - 6 digits (e.g. 2222-222222)
and some will be:
6 digits - 4 digits (e.g. 222222-2222)
I want to separate the three from each other.
i used a simple if statement:
If ActiveSheet.Cells(rownum, 1).numberFormat = ####-###### Then
yet it does not regonize the numbers on the sheet that are 4-6 digit numbers
the format for that column is set up as general, and obviously going through
all the numbers and individually setting up the format defeats the purpose of
having the program do it....What am i doing wrong?
Thanks a bunch,
Jordan
|