LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 505
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 automated annual date change Cheryl Excel Discussion (Misc queries) 7 August 23rd 06 12:29 AM
How do I flag a cell in Excel 2002 when the date entered has pass sas1950 Excel Discussion (Misc queries) 1 February 15th 06 04:52 PM
NETWORKDAYS - Multiple Date Selection Annabelle Excel Discussion (Misc queries) 3 October 4th 05 07:04 PM
search for latest date Sue Excel Worksheet Functions 2 August 2nd 05 11:09 PM
Date Button in Header (Excel 2000) Jim Excel Discussion (Misc queries) 1 December 11th 04 04:47 PM


All times are GMT +1. The time now is 11:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"