Posted to microsoft.public.excel.programming

Wescotte

external usenet poster

Posts: 28

Data validation/Formatting input

Is it possible to force the user to enter text in a very specific
format like for entering dates or similar syntax specific input?

Also, I setup a custom format of 0000"."0000"."00

When the user enters 123 it it switched to
0000.0001.23

Is it possible to reverse it so it would become 1230.0000.00 instead?

Thanks
Eric

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 input message	Wanna Learn	Excel Discussion (Misc queries)	1	January 14th 09 03:48 AM
Data Input Validation	Mark S[_2_]	Excel Discussion (Misc queries)	5	February 24th 08 12:00 AM
Data Validation - input message	yshridhar	Excel Discussion (Misc queries)	0	January 28th 08 05:22 AM
Data Validation-Input Mask	Smitty52	Excel Discussion (Misc queries)	5	August 29th 06 03:12 AM
DataValidationInput message	irresistible007	Excel Worksheet Functions	1	December 3rd 05 01:06 PM

All times are GMT +1. The time now is 11:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us