Posted to microsoft.public.excel.misc

KFred

external usenet poster

Posts: 2

Converting to Date Format

I inherited a spreadsheet in which the dates were input as 18.02.06. How can
I best convert this string into a proper date 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
Converting Numbers to Date Format	MB	Excel Worksheet Functions	2	February 6th 07 10:49 PM
Converting US Date Format	Neil Mitchell-Goodson	Excel Worksheet Functions	0	November 21st 06 12:20 PM
Converting date format	Brian	Excel Discussion (Misc queries)	2	May 2nd 06 02:31 AM
Converting to date format	ahaigh	Excel Discussion (Misc queries)	1	March 13th 06 06:54 PM
Converting number or text to a Date Format	samhain	New Users to Excel	2	October 17th 05 02:28 PM

All times are GMT +1. The time now is 02:16 AM.

About Us

"It's about Microsoft Excel"