How to format a date into a 2-digit code which indicates the year?

Hi.

I'm new here, so I don't know whether this question is already answered before. I need to format a date (for example 13.10.2009) into a code that indicates the year i.e. two last characters (for example 09).

The problem is that excel always turns them into number (40099 in this example) when I try to use any functions. So how is it possible to turn it into a form 13102009, which is not in a date format? After that I know that using the RIGHT function I can get the the last digits out. But I'm not able to do so before the format is changed, since it's in a date format and the result from the function is 99 in this case.

So please let me know how to format 13.10.2009 (date format) into 13102009 (general or number format) instead of 40099. Thanks for help.

Yes, it works perfectly with a minor change when , is replaced with ; Thank you very much, you saved me a lot of time.