Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training course - Validation Excel

excel training course - Validation Excel

ResolvedVersion Standard

Thu 30 Nov 2006, 14:38 Delegate Harold said...

Harold has attended:
Excel Intermediate course
Access Intermediate course

Validation Excel

Can you set a validation in excel on a range of texts ie other than the text length?The validation should limit the range for inputting text only? Eg Allow text only!

Fri 1 Dec 2006, 09:22 Trainer Orok said...

RE: Validation Excel

Hi Harold,

I am unaware of any validations in Excel that limit data inputs to text only. You can format cells to display numeric data as text, that is, it displays left aligned.

Please note that such validations are available in Access

Regards

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel training course - Validation Excel

Validation Excel

RE: Validation Excel

Excel articles

Excel tip:

Turn Function tooltips on and off