VBA to Change Cell contents

[NickWeth]

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

Please Login or Register  to view this content.

I thought the ?? would work as a wild card, maybe not.

Thanks
Nick

[StephenR]

Cross-post

http://www.ozgrid.com/forum/showthread.php?t=182388

[JOHN H. DAVIS]

Deleted.......

[NickWeth]

Sorry didn't know the 2 forums where connected, is it not allowed to post in more than one?

What has been deleted

[JOHN H. DAVIS]

Nick you should familiarize yourself with the Rules of each Forum you visit. For this one it is Forum Rule No. 8.

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

However since you are a new member and have less than 10 posts here is what was deleted:

Please Login or Register  to view this content.

It was my attempt at solving your problem.

[NickWeth]

Hi John

Thank you for the response, I wast aware of the rule I admit I didn't read all the forum rules, just wanted to try and solve my issue. I will stop using this thread from now and use the other.

Thank you for the information that was deleted and for your consideration.

Thanks
Nick