I have copied and pasted some data including times. Some times have a single
digit for the hour and when it pastes into Excel, that first digit comes in
as a space not a zero. Because of that, those fields seem to ignore all
formatting changes. Is there a trim function for times?
--
Oregon Julie