Re-organize date and units into different formats

Hi I hope you can help me with this.

I have approximetly 6000 rows of data extracted from a power meter that I have pasted into two columns of a 2010 excel spreadsheet.

Unfortunately the date, time, and unit formats do not meet the standard that I need to report to our customer.

In Column A the pasted date and time is formatted as: 27.01.2012 11:11:33

Is it possible using a worksheet function or VBA code to reformat the entire column's date and time to: 01/27/12 11:11:33?

Also in Column B the pasted row units for amerage is: 15,69

I would like to replace the comma with a period for 15.69.

I appreciate any help you can give me. I can navigate my way around excel, I just need a hint to get me on my way.

Thanks.

Will

Perfect, thank you very much!

I didn't close enough at the result. The days and months get crossed until the 12th. See below for examples

1/31/12 11:56 PM
1/2/12 12:11 AM (this should be 2/1/12)

12/2/12 11:56 PM (This is suppose to be 2/12/12)
2/13/12 12:11 AM

Thank you

Thanks but I must be missing something. I tried changing date format but excel thinks the result of your function is correct as January 2nd 2012 instead of February 1st 2012.

It is not that bad to manually fix. Thank you for your help