Happy New Year
Did you know that Excel can help with entering the new year in your dates.
Instead of typing 02/01/09 into a cell, just type 02/01 and excel will guess that this is a date and use the current year as a default.
Excel hints, Excel tips and Excel assistance
Excel Assist .co.uk
click a link to
buy me a beer
Recent Readers
Search This Site
Categories
Archives
- September 2010
- August 2010
- March 2010
- February 2010
- January 2010
- December 2009
- October 2009
- September 2009
- August 2009
- July 2009
- June 2009
- April 2009
- March 2009
- February 2009
- January 2009
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
Pages
Recent Posts
- Dialog Box tip
- Get the month name in Excel
- Microsoft Excel Tips
- Reducing the Size of Excel files. – Excel bloat
- Microsoft Excel Date Tips
- Adding the Excel Camera Tool to the Quick Access Toolbar – For Dummies
- Excel calculation on off button
- excel 2003 menu in 2007
- sort by cell colour
- excel page numbers
- Move and scroll within Excel worksheets
- Right Click keyboard shortcut
- convert accounting negatives
- Find() in vba
- Select Current Region
Tags
addins
camera
cell content
cell function
consolidate
copy paste
countif
Ctrl+End
Ctrl+Home
cut and paste
dates
delete blanks
drag and drop
email
Excel
format
format date
functions
hint
hints
intro
keyboard shortcuts
lists
number format
numbers
offset
page selection
paste special
range name
shortcuts
spelling
substitute
subtotal
sum
sumif
tab name
text
text case
text format
text to columns
tips
trim
twitter
vba
web query
New Year
Done!
Plugin created by Jake Ruston - Sponsored by Wrist Corsage.
