Excel Data conversion

From: Hans Kohls (hans_at_meinplanet.de)
Date: 07/27/04 

Date: Tue, 27 Jul 2004 13:37:44 GMT

Hello,

I have to convert the (afaik) Excel (internal) date format into a
different format.
I am wondering if there is a package around to do so. The excel Format
is something like 3NNNN and represents the number of days since 1.1.1900.

Cheers, Hans

Relevant Pages

  • RE: Export to Excel: 2nd, 3rd, etc excel files not opening up
    ... early bindings to use the built-in functions of excel to format my excel ... Well based on your suggestions my understanding is that in my early binding ... Set xlApp = New Excel.Application ... I also was able to format that same exported excel ...
    (microsoft.public.access.formscoding)
  • RE: Get parameter dates in heading
    ... And if it goes in Excel where do you put it. ... Const conLightGray As Long = 12632256 ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)
  • Re: mailmerge with txtfile
    ... I did not recognise the format as DIF. ... My assumption is that Excel does not know what to do with the LABEL ... Then go into the Open Data Source dialog (Select Data Source in Word ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Dragging data to Excel using DoDragDrop
    ... It just puts a "biff8" object into the clipboard, ... object into Excel. ... if you can use a native Excel data format from ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Text formatted cells displaying numbers in scientific format
    ... If Excel is, indeed, 'trying to be helpful', it's not doing a good job ... distinguishes the data in question from any other numeric string, ... has the cell display the value in line with it's format (i.e. ...
    (microsoft.public.excel)