ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   date year input (https://www.excelbanter.com/excel-discussion-misc-queries/46977-date-year-input.html)

LIVE SANDY

date year input
 
new @ this..in access you can put an input mask...date 99/99/99..is there a
way in excel or a way another year can be default

Dave Peterson

Change the date on your computer to last year??? (Yuck!)



LIVE SANDY wrote:

new @ this..in access you can put an input mask...date 99/99/99..is there a
way in excel or a way another year can be default


--

Dave Peterson

LIVE SANDY

Thanks!! I thought of that, however,it is for other computers as well and you
might as well type it if it is that much trouble, so especially (yuck!) But
since it was the first time I posted a question, it was nice to get a reply.
Thanks again Sandy

"Dave Peterson" wrote:

Change the date on your computer to last year??? (Yuck!)



LIVE SANDY wrote:

new @ this..in access you can put an input mask...date 99/99/99..is there a
way in excel or a way another year can be default


--

Dave Peterson



All times are GMT +1. The time now is 01:48 PM.

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