|Your date is probably being seen by Excel as text, not as a date.|
With 25.01.2011 in A1, try this:
This should return a 5 digit number that represents the date and that can be formatted anyway you want.
Excel stores dates and times internally as numbers, with the integer portion being the date and the decimal portion being the time.
If you want to remove the formula after the conversion to a 5 digit number, try this:
Right Click...Copy...Right Click...PasteSpecial...Values
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.