Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Heeelp!
Can anyone tell me what the role of the 'Validation' option in the dat menu is? is it a) It checks the worksheet for errors in your formulae or B) It allows you to set the properties of certain cells so that incorrect data cannot be entered and you are prompted with a message about the 'allowed' contents of the cell/cells. Thanks so much! -- Deadloss ------------------------------------------------------------------------ Deadloss's Profile: http://www.excelforum.com/member.php...o&userid=29859 View this thread: http://www.excelforum.com/showthread...hreadid=495636 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Heeelp!
Deadloss wrote...
Can anyone tell me what the role of the 'Validation' option in the dat menu is? is it a) It checks the worksheet for errors in your formulae or B) It allows you to set the properties of certain cells so that incorrect data cannot be entered and you are prompted with a message about the 'allowed' contents of the cell/cells. It's B, which online help states perhaps not clearly enough. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Heeelp!
B)
Regards, KL "Deadloss" wrote in message ... Can anyone tell me what the role of the 'Validation' option in the dat menu is? is it a) It checks the worksheet for errors in your formulae or B) It allows you to set the properties of certain cells so that incorrect data cannot be entered and you are prompted with a message about the 'allowed' contents of the cell/cells. Thanks so much! -- Deadloss ------------------------------------------------------------------------ Deadloss's Profile: http://www.excelforum.com/member.php...o&userid=29859 View this thread: http://www.excelforum.com/showthread...hreadid=495636 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Heeelp!
The answer is .b) well sort of, it has many function, I like to use it to put a drop down list in a cell, but it also does what you said, when properly set up it enables you to restrict data that is entered in a cell.....e.g say you wanted to restrict data to only numbers, in data validation you would select "custom" from the drop down list and in the formula bar you'd put something like this =ISNUMBER(A1), then you leave a message telling people what kind of data to put in, when someone tries to enter text your message appears. HTH JG -- pinmaster ------------------------------------------------------------------------ pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261 View this thread: http://www.excelforum.com/showthread...hreadid=495636 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Heeelp!
Hi Thanks for the help!! I really appreciate it. I have a set of 15 questions to do (Uni work). I've worked my way through most of them but I'm still stumped on 3 - This was one of them. I've already posted another question and I have another I have yet to post. If anyone would be so good as to have a look , I would be most grateful. GJ -- Deadloss ------------------------------------------------------------------------ Deadloss's Profile: http://www.excelforum.com/member.php...o&userid=29859 View this thread: http://www.excelforum.com/showthread...hreadid=495636 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|