Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Entering date in spreadsheet (excel 2000)

    Usually the date is entered in EXCEL spreadsheet like 01/29/04 for 29 January 2004. Is there anyway by which I can enter the date as 290104

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Entering date in spreadsheet (excel 2000)

    If you have your "regional settings" (windows setting via control panel) set to "dd/mm/yy" you can enter:
    29/01/04 and it will convert to date format. It will always then convert based on day entered first, then month, year so that:
    5/1/04 is Jan 5, 2004 not May 1, 2004.

    If you want to enter the number 290104, you would have to create a macro to convert this number to a date in the cell see for example the code in <post#=132034>post 132034</post#>

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Entering date in spreadsheet (excel 2000)

    Excel doesn't recognize 290104 as a date. You could use one cell for data entry and another cell to display the resulting date. Say that you use A1 for data entry; the following formula in B1 will return the corresponding date:

    =DATE((MOD(A1,100)<29)*100+1900+MOD(A1,100),INT(MO D(A1,10000)/100),INT(A1/10000))

  4. #4
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Entering date in spreadsheet (excel 2000)

    Thanks guys for the quick response.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •