sorry to be a pain! how can i now convert this to a text format? the cell i want it in is a variable in a webdata update. it does not recognise the weblink if the cell sshows it in any other format than text. i need the cell to show 2008-9-24, but as text!