Another way:

Select that range of "times"
edit|replace
what: A
with: " AM" (no quotes--just spacebar, AM)
replace all

(and the same with P and PM????)



Edmund Wong wrote:

I have series of times in a column that is formatted as 9:30a, 9:40a,
etc. How do I convert these to time, i.e., 9:30 AM, etc.?

thanks

--

Dave Peterson