Autodating on Excel 07

jkl11189 · 03-07-2009, 01:05 AM

I just want to put into a cell 10-20 exactly but excel keeps filling 20-Oct. I need numbers not a date.

Please help.

David M58 · 03-07-2009, 09:39 AM

You can type an apostrophe (') first, and then 10-20.

Or you can format the cell as text: Press Ctrl-1 to bring up the Format Cells dialog, and on the Number tab, choose Text, then enter 10-20.

jkl11189 · 03-07-2009, 09:52 AM

Press "Ctrl 1" just brought up a font menu. It had only one tab that said "Font". Also I'd rather not put a ' every time I want to input something that could read as a date. I'd rather just turn the function off all together. Is there a way to do that?

jkl11189 · 03-07-2009, 10:15 AM

Never mind. I thought the ' would stay up and always be showing. But it didn't. Thanks.

03-07-2009, 01:05 AM	#1 (permalink)
jkl11189 Registered User Join Date: Mar 2009 Posts: 3 OS: vista	Autodating on Excel 07 I just want to put into a cell 10-20 exactly but excel keeps filling 20-Oct. I need numbers not a date. Please help.

03-07-2009, 09:39 AM	#2 (permalink)
David M58 Registered User Join Date: May 2008 Location: Baltimore, Maryland Posts: 160 OS: Windows XP SP3	Re: Autodating on Excel 07 You can type an apostrophe (') first, and then 10-20. Or you can format the cell as text: Press Ctrl-1 to bring up the Format Cells dialog, and on the Number tab, choose Text, then enter 10-20.

03-07-2009, 09:52 AM	#3 (permalink)
jkl11189 Registered User Join Date: Mar 2009 Posts: 3 OS: vista	Re: Autodating on Excel 07 Press "Ctrl 1" just brought up a font menu. It had only one tab that said "Font". Also I'd rather not put a ' every time I want to input something that could read as a date. I'd rather just turn the function off all together. Is there a way to do that?

03-07-2009, 10:15 AM	#4 (permalink)
jkl11189 Registered User Join Date: Mar 2009 Posts: 3 OS: vista	Re: Autodating on Excel 07 Never mind. I thought the ' would stay up and always be showing. But it didn't. Thanks.