how can I convert a date cell eg. 05/12/2005 to text. In other words I would like to seperate the numbers to three different columns. I trie using the 'Data ->Text to Column' include the '/' as the seperator but still it wouldn't do that.

Appreciate any assistance