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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to tell if cell value is time or not 5
How to assign unit for TimeValue? 20
Display entire number in cell 3
Conditional Validation In Excel 1
Check date 2
Excel is changing date format incorrectly 7
conditional format -- if not a date, then highlight cell 1
Excel VB - Testing Month within a blank cell 7

Back
Top