Posted to microsoft.public.excel.misc

Laurie

Posts: n/a

data validation and formatting

I want users to be allowed to enter a seven character response in a cell.
The seven character response must be in the following format - number number
letter letter number number number. I specified the length of the entry by
using the data validation feature but I don't know how to ensure that the
response is in the right format. I'm using Microsoft Excel 2002. Any
suggestions?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Validation - ignore blanks	Neville	Excel Discussion (Misc queries)	10	November 9th 05 02:03 PM
Data Validation	DLM	Excel Discussion (Misc queries)	2	February 22nd 05 02:26 AM
Effect of Conditional Formatting, Data Validation	Bill Sturdevant	Excel Discussion (Misc queries)	1	January 25th 05 11:50 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	0	November 18th 04 03:13 PM

All times are GMT +1. The time now is 11:44 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us