Date function

[Prasad Gopinath]

I have to manually input a huge number of dates. it becomes very tedious to do this if I have to use the seperators. EG
10/09/2004. Is there any way I can input this 10904 and then converst it to read 09 Oct 2004. Any tips will be appreciated

Prasad

 

[Vasant Nanavati]

Look at Chip Pearson's site:

http://www.cpearson.com/excel/DateTimeEntry.htm

--

Vasant

I have to manually input a huge number of dates. it becomes very tedious

to do this if I have to use the seperators. EG.

10/09/2004. Is there any way I can input this 10904 and then converst it

to read 09 Oct 2004. Any tips will be appreciated.

 

[Prasad]

Vasant

I am not an expert in Excel. I went to the page you postred and got all the entries. Now, my question is where do I go to input this in the Excel sheet.

 

[Gord Dibben]

With your workbook open and your worksheet in front of you.

Select the sheet tab and "View Code".

A blank module will open.

Copy the first set of code(blue lines) from Chip's site. This code is for
entering Dates.

Paste into the sheet module. Hit ALT + Q to go back to your worksheet.

Save your workbook.

Start entering numbers into column A.

The second set of code is for entering Times.

Gord Dibben Excel MVP

 

[Ragdyer]

If these dates are to be entered into a column, and you would prefer another
approach beside using code, you could use <Data> <TextToColumns>.

HOWEVER, you *must* follow a standard entry format for this to work!

What you used in your example was *not* a good entry format.
10904 might be interpreted as Jan 09,2004.
See what I mean?
100904 would be acceptable for this procedure to work, namely 2 digits for
each date specification, although the leading zero for the month
specification, since its the first entry, will be dropped by XL in a General
formatted cell anyway (as in your example equating to Jan).

With the *properly * entered numbers in a column, select the column, then
<Data> <TextToColumns> <Next> <Next>
Click in "Date", and make sure "MDY" is displayed in the adjoining box, then
<Finish>.

Now, while the column is still selected (and displaying true dates), custom
format the column to your desired date format (dd mmm yyyy).
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Vasanth

I am not an expert in Excel. I went to the page you postred and got all

the entries. Now, my question is where do I go to input this in the Excel
sheet.