ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exel Calender drop down box 2005 (https://www.excelbanter.com/excel-discussion-misc-queries/4490-exel-calender-drop-down-box-2005-a.html)

Allen_bax

Exel Calender drop down box 2005
 
Trying to set up a drop down Calender box, within a Exel Spreadsheet for 12
month period--showing months & days.
Advice Please.


Trevor Henry via OfficeKB.com

Could anyone tell me how I could have excel fill in the date info for my travel expenses? I do a monthly report that I have to use at the end of the year for my taxes.

--
Message posted via http://www.officekb.com

JulieD

Hi Trevor

how would you like to do it. If it's the current date you're after then the
shortcut key combination of ctrl & semi-colon (;) should work.

other than that a bit more information about how your workbook is setup,
what date you want entered etc is required.

Cheers
JulieD

"Trevor Henry via OfficeKB.com" wrote in message
...
Could anyone tell me how I could have excel fill in the date info for my
travel expenses? I do a monthly report that I have to use at the end of
the year for my taxes.

--
Message posted via http://www.officekb.com





All times are GMT +1. The time now is 02:34 PM.

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