I have date in this format - 30.11.2006.Now this is actually not the proper format for date.No conditional formatting can be applied,neither the difference between two dates in same format can be calculated.I've tried to format the cells but it isn't working.Now I want the dates to appear in the same above format where all types of formulas,conditional formatting etc.can be applied.Is it possible?Please help.