Hi,
I have (rather stupidly) put myself up to whip up a spreadsheet for
work which is due to be unveiled at a meeting this morning.

there are a few things which i'm struggling on, although i'm certain
they are relativley simply to implement.

1. I need to restrict the date entry so that it views with /slahes as
apposed to anything else. So even if someone inputs 29.11.05 it will
automatically default to 29/11/2005
2. Similar problem with the time i need the time to default to 12:00 as
opposed to 12.00 or any other value

This is because they are going to be exported into a database and nned
to be in that format to export properly.

Also i need to create a drop down list of suppliers to selct from. How
do i do that?

Finally, how do i create a box to automatically email to a designated
mailbox?

Thanks so much to anyone who can help, i am praying i can get this done
by tomorrow or else i'm goosed.

Thanks

Luke


--
Dolalu
------------------------------------------------------------------------
Dolalu's Profile: http://www.excelforum.com/member.php...o&userid=29188
View this thread: http://www.excelforum.com/showthread...hreadid=489143