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 ***

Hi, you can of course just type this in cell A1 =Today(), and it wil
displays todays date so if you open the workbook tomorrow it wil
display tomorrows date!

HTH

Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=51518

Ctrl & ;
control -semi-colon gives you the date;
if you want a specific format goto
format,cells,number,date
then select the format you want, this only applies to the range you
have highlited, be it one cell ar many

- Goto "DATA-Validation"
- From "Allow" drop-down select "Date"
- from "Data" select somthing you want




Bye
Regards
NAVEEN


"tom taol" wrote:



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 ***