If there was a way to have a formula that split, or moved the am/pm to
another column, while keeping only the Numeric value in the first column.

Or if I could Export the data to Word or another program, format it from
there, and re-FTP and save it under a new name.

Just thoughts

"Mic" wrote:

Is there a way to:

Take a column that is formated to hh:mm AM/PM to remove the am or pm in the
same column (Think that it would have to be text)

Or

Start with Text that 8:30 and make it 08:30 without the AM/PM

Mic