Excel Date Format in Array

[will never learn]

Hello all,

I am copying data from a .csv file to another excel file using _ExcelReadSheetToArray().

Problem is, that when I am reading the dates from the .csv file (i.e. 30.06.2010) to the array, the format is changed and the value in the array (as displayed with _ArrayDisplay() is "20100630000000".

This means, that when I am inserting the data to another excel file, I cannot compare the different dates. I tried re-creating the dates in the new sheet using =Concatenate() (in Excel), but the result is only formatted as text.

Does anyone have a fix for this problem?

Thank you very much

[PsaltyDS]

You can create a copy of the function (rename it to avoid confusion) and change the method used to read the cells from .value to .text, for example:

; Old line:  $avRET[$r][$c] = $oExcel.Activesheet.Cells($iStartRow + $r - 1, $iStartColumn + $c - 1).Value
$avRET[$r][$c] = $oExcel.Activesheet.Cells($iStartRow + $r - 1, $iStartColumn + $c - 1).Text

The value is the way Excel saves that data type. The text is the way it presents it on the sheet.

Edited August 5, 2010 by PsaltyDS