Adding A Space Within Text

[Mediaexcel]

Hello

I am trying to convert a column into time format.
This is how I got it

03:38:27AM
10:08:27AM
01:36:59AM
01:51:56AM
03:56:22AM
04:17:06AM
04:39:35AM
06:13:32AM
09:22:30AM
10:17:58AM
10:24:40PM
10:47:21AM
11:47:24PM

For excel to recognize it in TIME format, I have to insert a spac
before the AM or PM.

Any suggestions

 

[Mediaexcel]

Thank you both ways worked just fine....

I have another little problem.

One of the columns has the values that I need to convert to numbe
format, however it seems that the values have a space before them an
therefore I cannot format it as a number.

I have attached the column as I got it.

thank you for your help

S

Attachment filename: number format example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=52234

 

[JE McGimpsey]

Try Data/Text to Columns... Click Finish in the first pane.

 

[Mediaexcel]

Thank you!!!! It worked