try the following:

In the format/Cells menu you can enter user defined formats.

Excel won't accept slashes in user defined format so you have to mark
as special character by adding a backslash in front of. Just like
this:

####\/##\/##

# stands for a variable digit


if doesn't work, try to declare / as text by adding double quotes
(####"/"##"/"##)

good luck ;),
Simon


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