ASP -> Excel Date Problems

Discussion in 'ASP General' started by Bryan Harrington, Sep 13, 2004.

  1. Hello all.. I've got a table of data that PHB wants to be able to download
    to excel to run pivot tables on.

    No problem.. got all that working.. the catch though is that there is a
    column in the data that shows the Invoice Date, next column shows the
    Invoice Month and Year in the format of mmm-yy.

    Works great in the browser.. when you download it to excel, Excel turns
    SEP-04 into 4-Sep-2004, anybody have a good way to format the date so Excel
    doesn't "fix" it for me?

    Thanks!
    Bryan Harrington, Sep 13, 2004
    #1
    1. Advertising

  2. You can precede the values with a ' to keep your format.

    <td>'<%=yourDate%></td>

    Ray at home

    "Bryan Harrington" <> wrote in message
    news:%...
    > Hello all.. I've got a table of data that PHB wants to be able to download
    > to excel to run pivot tables on.
    >
    > No problem.. got all that working.. the catch though is that there is a
    > column in the data that shows the Invoice Date, next column shows the
    > Invoice Month and Year in the format of mmm-yy.
    >
    > Works great in the browser.. when you download it to excel, Excel turns
    > SEP-04 into 4-Sep-2004, anybody have a good way to format the date so

    Excel
    > doesn't "fix" it for me?
    >
    > Thanks!
    >
    >
    Ray Costanzo [MVP], Sep 13, 2004
    #2
    1. Advertising

  3. Thanks Ray..

    That's another Head Slapping DUUHHH! Funny how sometimes the obvious isn't!




    "Ray Costanzo [MVP]" <my first name at lane 34 dot commercial> wrote in
    message news:%...
    > You can precede the values with a ' to keep your format.
    >
    > <td>'<%=yourDate%></td>
    >
    > Ray at home
    >
    > "Bryan Harrington" <> wrote in message
    > news:%...
    > > Hello all.. I've got a table of data that PHB wants to be able to

    download
    > > to excel to run pivot tables on.
    > >
    > > No problem.. got all that working.. the catch though is that there is a
    > > column in the data that shows the Invoice Date, next column shows the
    > > Invoice Month and Year in the format of mmm-yy.
    > >
    > > Works great in the browser.. when you download it to excel, Excel turns
    > > SEP-04 into 4-Sep-2004, anybody have a good way to format the date so

    > Excel
    > > doesn't "fix" it for me?
    > >
    > > Thanks!
    > >
    > >

    >
    >
    Bryan Harrington, Sep 13, 2004
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matt
    Replies:
    1
    Views:
    588
    Matthew Speed
    Nov 8, 2003
  2. Peter Grison

    Date, date date date....

    Peter Grison, May 28, 2004, in forum: Java
    Replies:
    10
    Views:
    3,229
    Michael Borgwardt
    May 30, 2004
  3. Matt
    Replies:
    2
    Views:
    505
    Pete Becker
    Nov 8, 2003
  4. Replies:
    2
    Views:
    12,296
    Babu Kalakrishnan
    Sep 14, 2006
  5. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,484
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
Loading...

Share This Page