The Cellar - View Single Post

elSicomoro · 09-25-2007, 10:09 AM

Hey folks,

I'm trying to type up a schedule for the drivers at my job; however, I keep running into the following problem: I want to type "11-4," for a shift, but Excel keeps turning that into a date. How can I type something like that into a cell without it turning into a date? I've tried using the number settings, but it keeps turning the number into something like 39,000.

Thanks.

09-25-2007, 10:09 AM	#1
elSicomoro Person who doesn't update the user title Join Date: Jan 2001 Posts: 12,486	Hyphen issue with Excel Hey folks, I'm trying to type up a schedule for the drivers at my job; however, I keep running into the following problem: I want to type "11-4," for a shift, but Excel keeps turning that into a date. How can I type something like that into a cell without it turning into a date? I've tried using the number settings, but it keeps turning the number into something like 39,000. Thanks.