ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Date entry (https://www.excelbanter.com/excel-discussion-misc-queries/18919-date-entry.html)

magstate

Date entry
 
How can I enter a date without having to type a "/" between the month, day,
and year?

Paul B

magstate, have a look here
http://www.cpearson.com/excel/DateTimeEntry.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"magstate" wrote in message
...
How can I enter a date without having to type a "/" between the month,
day,
and year?




Bob Phillips

If you have a lot of dates to enter, take a look at

http://www.xldynamic.com/source/xld.QDEDownload.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"magstate" wrote in message
...
How can I enter a date without having to type a "/" between the month,

day,
and year?





All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com