Hi, our application is exporting data to a spreadsheet. Using the
Excel.Application object. We are formatting the date fields using

app.Range(strCol & strRow).EntireColumn.NumberFormatLocal = "standard"

This usually works just fine, however sometimes some of the rows gets a
different format. E.g.
12.12.2003 Right aligned
12/12/2003 left aligned
Then I made this small macro that adds a comment with the NumberFormat and
NumberFormatLocal for the cells. And all the cells had
dd.mm.åååå In Numberformatlocal
and
d/m/yyyy in NumberFormat
So some of the rows were using NumberFormatLocal to format the dates while
some others were using NumberFormat. I then tried to change the format on
some the cells that were using just numberFormat, but it still showed in
the NumberFormat.

So I was wondering how does excel decide which format to use?
And does anyone know the values NumberFormatLocal can have?
Regards Martin