>>>In Excel automation, how to display date fields in DD/MM/YYYY format. At present it
>>>is displayed as MM/DD/YYYY format. thnaks in advance.
>>
>>You can ask Excel:
>>
>>Start recording a macro, and give the command - in this case, change the date format. Then, stop recording the macro.
>>
>>Now, look at the macro; you will see code similar to:
>>
>>
>>Selection.NumberFormat = "dd-mm-yyyy;@"
>>
>>
>>Now apply this to a cell, column, or range, for example:
>>
>>
>>loSheet.Cells(5,4).NumberFormat = "dd-mm-yyyy;@"
>>
>>
>>(Does somebody know what the "@" at the end means?)
>
>"@" usually means the cell is viewed as text, not as a number or whatever.
I tried to concatenate the results with some other text, but I get no difference, whether the format includes ";@" at the end or not. (In both cases, the date was treated as a serial number.)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
