Date function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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 !
---------------------------------------------------------------------------
Prasad said:
Vasanth

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