I have a column that consists of some cells with just a date in this format: mm/dd/yyyy, but most of the cells have mm/dd/yyyy (initials). Up to this point we have been manually typing in the current date and our initials and we've been including the 0 on the date (5/03/2007) so it will sort correctly. I made a macro today that will automatically enter in todays date and the initial of the person entering it but it enters todays date as 5/3/2007 so it will not sort correctly. Does anyone know of a way to fix this?
Bookmarks