date

[spoefi]

hello,

Via vba-code in Word, I give a cell in Excell a date-format and then
put a date in it. All goes well (it doesn't even change the months an
the days!).

but when i look in the excelfile, the date is still aligned to th
left, which means Excel doesn't recognize it as a date.

However, when i doubleclick on the cell and then leave the cell, i
aligns it to the right and it is recognized as a date.

how could i incorporate that in my code?

thanks!

mySheet.Cells(ixRow, 5).NumberFormat = "dd/mm/yy"
mySheet.Cells(ixRow, 5).FormulaR1C1 = Selectio

 

[Tom Ogilvy]

After you get the values entered, Select the column

Edit=>Replace
Replace \
With \

If you want code, use the macro recorder.