MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Thank Mark- still having problem..Is there a way to....

Posted by JIM BYRNE on February 14, 2002 12:42 PM

put a leading zero in front of the months that arent in the mm/dd/yy format.

Posted by Mark W. on February 14, 2002 12:53 PM

Select one of these troublesome dates...

...look at the formula bar and tell me if you see
a leading apostrope (').