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

how to input date only in A1 cell.
 

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

how to input date only in A1 cell.
 

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

how to input date only in A1 cell.
 

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