Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a formated date button for Excel 2002 tool bar
Dear Sir,
May I know is there a way to add a Formated Date Button to the tool bar for Excel 2002 ? I am currently using MS Excel 2002 in my office. Usually when I would like to convert a number to date, I would right click the mouse, go to format cell, then to date, then to locale, choose English (Australia) then select 14/03/01. The date is convertyed correctly. However when I tried to add a date button to the tool bar, I could not find any date button under "customized tool bar" for me to drag out. May I know is there a way to add a Formated Date Button to the tool bar for this version of Excel ? If not is there any other shorter way of doing it ? Please help. Thanks Low -- A36B58K641 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add a formated date button for Excel 2002 tool bar
CTRL + ; will enter a static date.
Or a macro you can assign to a button on your toolbar. Sub NOWDATE() ActiveCell.Value = Format(Date, "dd/mm/yy") End Sub Gord Dibben MS Excel MVP On Mon, 30 Oct 2006 04:14:01 -0800, Mr. Low wrote: Dear Sir, May I know is there a way to add a Formated Date Button to the tool bar for Excel 2002 ? I am currently using MS Excel 2002 in my office. Usually when I would like to convert a number to date, I would right click the mouse, go to format cell, then to date, then to locale, choose English (Australia) then select 14/03/01. The date is convertyed correctly. However when I tried to add a date button to the tool bar, I could not find any date button under "customized tool bar" for me to drag out. May I know is there a way to add a Formated Date Button to the tool bar for this version of Excel ? If not is there any other shorter way of doing it ? Please help. Thanks Low |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 automated annual date change | Excel Discussion (Misc queries) | |||
How do I flag a cell in Excel 2002 when the date entered has pass | Excel Discussion (Misc queries) | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Date Button in Header (Excel 2000) | Excel Discussion (Misc queries) |