Smurfoz

Posts: n/a

Date Format

When entering a date in Excel what format should be used to allow the user to
only key the actual characters. For example, we want to key in 17102005 and
would like this to show in the cell as 17/10/2005. We are having problems
with this

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
Compare dates (one cell not in date format)	craigcsb	Excel Discussion (Misc queries)	5	June 28th 05 05:07 PM
How do I keep the date from changing format in a mail merge?	Brynn Wilson	Excel Discussion (Misc queries)	1	June 9th 05 06:44 PM
Date format	Jean-Francois Boucher	Excel Discussion (Misc queries)	2	February 22nd 05 04:35 PM
USING THE DATE FORMAT IN EXCEL	teach	Excel Discussion (Misc queries)	3	December 14th 04 11:55 PM
Date format collapses diagram	Richard H	Excel Discussion (Misc queries)	3	December 14th 04 11:08 PM

All times are GMT +1. The time now is 07:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us