Siteman wrote:
It looks like it defineatly has to do with the export having the am/pm in the
number cell,
if i find all am and pm and replace with nothing, in other words remove the
refernce, then excel automatically puts in caps AM - which of course does not
work either. I suspect now it has to be on a 24 hour clock so that excell
can figure that out, i will try this let you know how it works out.
hopefully the software that i am exporting from has this option.



See David Biddulph's response. Basically, replace "AM" with " AM" and replace
"PM" with " PM". Then see if it works for you.