Hi All,

I was wondering if it is possible to remove the date from a timestamp. I have a worksheet with thousands of rows, and don't want to manually do it.

The date currently shows like this: 04/20/09 7:30:00 AM

I just want the 7:30:00 AM portion. I can reformat the cells to show only the time, but the value still have the date.

Does anyone know if this is possible?

Thank you