Restrict entry types

[Dolalu]

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

[Dave Peterson]

1. One way is to use data|validation to allow them to only enter dates--any way
they want--but they have to be dates.

Data|validation|allow Date (and give a nice range).

It won't help the user if he/she types 12.31.2005, but it will yell at them.

2. Same kind of thing with Time.

3. Look at Data|validation and allow a list.

Debra Dalgleish has some very nice instructions (including pictures) for working
with data|validation at:
http://www.contextures.com/xlDataVal01.html

In particular:
http://www.contextures.com/xlDataVal01.html#Dropdown

4. Tell them to hit file|send to (and do some typing)

or you could read all about sending email using excel at Ron de Bruin's site:
http://www.rondebruin.nl/sendmail.htm


Dolalu wrote:
>
> 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

--

Dave Peterson