Posted to microsoft.public.excel.misc

Aditya

external usenet poster

Posts: 54

date entry new

Data in column A is of 8/9/10 or 11 digit.
However in every case last 6 digit is in form of ddmmyy. how can i get date
from this in column B.

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
Excel 2002 date entry: Cannot get away from d-m-yy entry format	Steve Eklund	Excel Discussion (Misc queries)	3	May 11th 09 04:57 PM
date entry	medavino	Excel Worksheet Functions	1	January 14th 08 06:08 PM
Date Entry	Daniel L. Lieberman	Excel Discussion (Misc queries)	1	May 3rd 07 04:13 AM
Restricting date entry relative to current date	bwalshjr	Excel Worksheet Functions	1	April 10th 07 12:49 PM
Date entry	magstate	Excel Discussion (Misc queries)	2	March 23rd 05 07:15 PM

All times are GMT +1. The time now is 01:11 PM.

About Us

"It's about Microsoft Excel"