hi all,

I have a spreadsheet which has two colums full of numbers, they are
dates but just written as numbers i.e. 20050923 for today's date. How
can I change them so that they show up as 2005/09/23? I've tried to
customize them but it won't work.
thanks!


--
bluebean
------------------------------------------------------------------------
bluebean's Profile: http://www.excelforum.com/member.php...o&userid=25951
View this thread: http://www.excelforum.com/showthread...hreadid=470165