Thank you both Domenic and jamescox, both dolutions work fine.
Chris

"jamescox" wrote:


An easy way to do this is to select the cell, format the cell to General
and then without exiting the cell press F2 and then the Enter key.

If you just select the cell and change the format from Text to General,
Excel may not actually change the format...


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113145