From Access 03 I can change the NumberFormat Property of an Excel 03
cell. For cell say F10 if original Date format was "dd/mm/yyyy"
I can change it to "m/d/yyyy"

objResultsSheet.Range(F10).NumberFormat = "m/d/yyyy"

Do you know what are the repercussions of this change? The cell value
was originally 14/3/2011. It still is and this logical since my
Regional Settings have not changed.

In other words what is the use of the NumberFormat property?

Thanks,
John

There are no repercussions except that you can look at the number in
the format that you like. It has the same effect as changing the
background color or changing the font.


On Mar 25, 3:56*am, JohnP <j... (AT) kosmosbusiness (DOT) com> wrote: