I think its the bug coz I tried the same after reading you're comment and it was working. The only problem is people within business are on 03 so. I have to look for solution. Can't provide 10 version to these people. they ill have a heart attack. I imported the Data in Pivot and then changed the format will check to see if this makes a difference.