|[quote]Format, Cell, Date, Change Locale to English (United Kingdom). You'll see the option you want.[/quote]|
That one works perfect. Thanks for that
[quote]Format, Cells, Custom[/quote]
Are you saying I have to modify pound (hash) sign under custom option ?
For instance this is one of those custom formats :#,##0;[Red],-#,##0.00
Or the picture in this link
Or Do you mean I have to chose ready made date format under custom option ?,,if you meant this , then there is no such an option that I am after