Posted to microsoft.public.excel.worksheet.functions

kwood525

external usenet poster

Posts: 3

date formatting in excel

I am trying to set up my date formatting so that I do not have to type in the
forward slashes when I input the date. I would like to be able to just type
in the date numbers: 083007

and have it automatically convert to: 08/30/07 when entered.

any tips?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Eliminate Excel date formatting	stevekfbc	Excel Discussion (Misc queries)	3	April 18th 06 06:06 PM
Formatting the Date in Excel	JD	Excel Discussion (Misc queries)	3	July 14th 05 11:07 PM
Excel 2002 Date Formatting	skoladycz	Excel Discussion (Misc queries)	1	April 6th 05 06:43 PM
How do I disable automatic date formatting in excel?	tcuneio	Excel Discussion (Misc queries)	1	January 21st 05 10:47 PM
Date formatting in Excel	vanness95678	Excel Discussion (Misc queries)	1	January 10th 05 11:24 PM

All times are GMT +1. The time now is 02:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us