Posted to microsoft.public.excel.misc

John Weaver John Weaver is offline

external usenet poster

Posts: 1

Convert military date system to standard date system

A former employee recorded all dates as 090917 (yymmdd, September 17, 2009)
as text format.

How do I convert this format to 09/17/09, mm/dd/yy format?

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
Difference betwen Excel Date () Function and System Date	Khalil[_2_]	Excel Worksheet Functions	2	June 16th 09 01:10 PM
Difference System date and Excel Date function	Khalil	Excel Worksheet Functions	2	June 16th 09 11:23 AM
Date system	mike	Excel Discussion (Misc queries)	8	March 3rd 08 11:46 AM
date system	The Rook[_2_]	Excel Discussion (Misc queries)	1	March 15th 07 12:04 PM
What is the "system date" in Excel?	ceedeem	Excel Worksheet Functions	1	December 21st 04 07:55 PM

All times are GMT +1. The time now is 04:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us