Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

How do I create list validation from code without the text being converted into date format?

I have a cell whose validation is dynamically changed. I delete and
create it from code. Some of the text that could be used is in the
format of x-y (e.g. 5-7), which sometime is converted into a date (e.g.
7-May). This happens in the Validation.Add function, which means I
can't solve it by just formatting the cell to contain Text.

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
when loading csv file to Excel, cells get converted to date format	RB	Excel Discussion (Misc queries)	3	February 14th 07 07:54 AM
Date converted to Text Number	Mari	Excel Discussion (Misc queries)	6	July 29th 06 03:15 AM
Text is being converted to Date	kbreiss	Excel Worksheet Functions	4	November 16th 05 10:09 PM
data validation list drop down text format too small	Bruce Edwards	Excel Worksheet Functions	3	May 22nd 05 07:28 PM
code to convert date from TEXT format (03-02) to DATE format (200203)	Gauthier[_2_]	Excel Programming	0	September 22nd 04 03:26 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us