Basic Find, Replace and Format change macro

Hi,

I am just learning how to write macros and need some help. Here is what i need:
-I need the macro to only search within column "B"
-There is both a date and time within the cell, the time is always " 00:00:00" and I need it to be replaced with blank/ ""
- The date is represented "1/1/2013" and i need the "/" to be turned into "-"
- and i need the number format to be changed to a custom format of "m-d-yyyy"

if anyone can help with any part of it I would really appreicate it.

Hi cmphibbs

Welcome to the forum.

Why do you need a macro to do this? If you go to number format and select custom, type in m-d-yyyy it should achieve what you want without the bother of a macro.

If you really want a macro, the you could start by recording the steps outlined above.

Let me know if I can assist further.

Regards
Alastair