$$Excel-Macros$$ Re: How to remove Invisible symbols in a cell.

Hi Paul Willekens, some of the cells are followed by " mm/dd/ hh:mm"(24Hrs ) format some of the followed by "mm/dd/ hh:mm AM/PM" i want "mm/dd/ hh:mm AM/PM". thx for u r sugesstion and i tried below customize from cell Format menu. thanks in adv. Mynamp

$$Excel-Macros$$ How to remove Invisible symbols in a cell.

Hi experts, I have a huge date with time data some of the cells shown MM/DD/ Hr:MM format Some of the cells shown MM/DD/ Hr:MM AM/PM format how I convert MM/DD/ Hr:MM format. I am not expecting below copy format. Or press F2 next press home next press back space . -- ---