Hi

I currently have a column which contains cells that should appear as, some do and some don't.
62-55-93
88-56-99

The data is originally exported from another program as a csv file and in certain cases the cell contents appear as a date format
10/10/10 should be 10-10-10
22/11/34 should be 22-11-34

What I am trying to do is create code which will go down the column and change the contents. At the moment I am having problems just trying to identify which cells need altering. My code is

Dim Rws As Long, Rng As Range, c As Range
    Rws = Cells(Rows.Count, "BD").End(xlUp).Row
    Set Rng = Range(Cells(1, 56), Cells(Rws, 55))

    For Each c In Rng.Cells
        If c Like "00-00-00" Then c = ""
        If c Like "??/??/??" Then c = "Alter"
    Next c
I thought the ?? would work as a wild card, maybe not.

Thanks
Nick