| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Format of Date in Header
You have a very limited control over this by your short date settings in Windows
Regional and Laguage settings. The closest I can achieve is 21-04-08 from those settings Otherwise see Ryan's macro solution. Gord Dibben MS Excel MVP On Mon, 21 Apr 2008 05:48:01 -0700, Sriram wrote: Hi All, While inserting &[Date] in the Header of an Excel Worksheet, the date on my Print appears as 4/21/2008 which is not the way I want. I want it displayed as 21-Apr-2008. And I do not find any formatting button as in the case of a normal excel Worksheet where we can choose from the date Templates available. Any help would be greatly appreciated. Sriram |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format of Header Date | Excel Discussion (Misc queries) | |||
| Format Header Date | Excel Discussion (Misc queries) | |||
| Excel 2003 can you change the header date format? | Excel Discussion (Misc queries) | |||
| how do I put the day into my header with the date have it change d | Setting up and Configuration of Excel | |||
| how do I change date format in the header in Excel XP ? | Excel Discussion (Misc queries) | |||
Threaded Mode
