how to input date only in A1 cell.

  • Thread starter Thread starter tom taol
  • Start date Start date
T

tom taol

i want to input the date only not text,time in the A1 cell.
using validation....
for example
=isdate(a1)
 
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
 
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
 
Back
Top