Posted to microsoft.public.excel.programming

tom taol

external usenet poster

Posts: 52

how to input date only in A1 cell.

i want to input the date only not text,time in the A1 cell.
using validation....
for example
=isdate(a1)

*** Sent via Developersdex http://www.developersdex.com ***

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
Date Input to Cell with pop-up calendar	Jay	Excel Discussion (Misc queries)	2	January 8th 08 06:48 PM
input a date or update it based on date in another cell	Doug P	New Users to Excel	1	July 18th 07 11:25 PM
Cell value input date	Mick[_3_]	Excel Programming	3	January 13th 05 09:55 AM
Having input the current date in a cell I want to lock it	Dave Peterson[_3_]	Excel Programming	1	August 27th 04 01:22 AM
Having input the current date in a cell I want to lock it	JE McGimpsey	Excel Programming	0	August 26th 04 08:20 PM

All times are GMT +1. The time now is 06:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us