Hi Russell, I did originally want it to have "/"'s in but thats no longer a requirement.

I've tried to format the cells and still no joy. the bizarre thing is when I copy and paste only the values into another cell...I still can't format it or custom format it etc. it's set in stone. I've not come across this issue before.