I have a time sheet that requires a space be enter between the time and AM or
PM, 1:00 PM instead of 1:00PM. Entery without the space gives "#Value!" in
the destination cell. Is there a way of formating this so as the person doing
data entery can omit the space and yet the space shows after they hit enter,
or not there after they hit enter? Does it matter? I have tried formatting
without the space through custom formatting and that does not seem to change
anything. (xl2000 on xp)