|  | €uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides. | 
|  10-26-2006, 02:35 PM | #1 | 
| I Floop the Pig | 
				
				Excel date formats
			 Okay, so I know how to take a date that's entered as digits and have it automatically format to the text version.  But what about the other way around?  If I put "Oct 26, 2006" in a cell, I want it to automatically convert to 10/26/2006 Possible? 
				__________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ | 
|   | Submit to Quotes   |