uk date format
If you are using a UK keyboard typing CTRL+# on a date cell will format the date to dd-mmm-yy.
The US keyboard is CTRL+SHIFT+#
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
- 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
- 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
- directory list using Excel
- SUBTOTAL formula (function)
- Sizing objects to cells
- number format #,##0.00
- uk date format
- How to Jump To a Specific Page in Excel
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.
