+ Reply to Thread
Results 1 to 3 of 3

Preventing Excel from converting Numric Dates to Descriptive dates

  1. #1
    Registered User
    Join Date
    04-14-2009
    Location
    Haryana, India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Preventing Excel from converting Numric Dates to Descriptive dates

    There are often requirements to generate Excel reports from Database applications.

    In such scenarios, I often generate valid Html from the data, and export it with a .xls extension relying on Excel capabilities to process Html.

    In such recent scenario, I was preparing a report, which had the following in it:

    <td>06-07</td>

    Excel automatically rendered it as 7 Jun. Clearly this is not the desired behavior. I wrapped it as:

    <td><![CDATA[06-07]]></td>

    This time Excel showed nothing in the cell. I even tried wrapping it in <pre>, but Excel now simply used a different font, but still rendered it as 7 Jun.

    Is there any way to specify in Html that Excel should display the data as is without applying any transformations whatsoever??

  2. #2
    Registered User
    Join Date
    12-16-2006
    Location
    Bangkok
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: Preventing Excel from converting Numric Dates to Descriptive dates

    try fomatting it as text

    cheers, francis

  3. #3
    Registered User
    Join Date
    04-14-2009
    Location
    Haryana, India
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Preventing Excel from converting Numric Dates to Descriptive dates

    Quote Originally Posted by franciz View Post
    try fomatting it as text

    cheers, francis
    Can you elaborate a bit more?? How do I format it as text in Html??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1