Re: Excel 2000 Header Date Format..

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I set my Windows short date settings this way:

Control Panel, Regional and Language Options, Regional Options tab, Short date: 29-Jan-09

So even though it's set that way, Excel is going to replace the Jan with 01?

How do I run a macro?

Gord Dibben wrote:
Excel takes the header date from your Windows short date settings.

You cannot change that setting to the format you want to see.

You can run a macro to set the date as you wish.

Sub header_date()
ActiveSheet.PageSetup.RightHeader = Format(Date, "dd mmmm yyyy")
End Sub


Gord Dibben MS Excel MVP

On Thu, 29 Jan 2009 09:37:33 -0600, JD <JD@xxxxxxxxxxxxxxx> wrote:

I'm moving from MS Works to MS Office 2000.

In Excel, the date in the Header is all numbers, for example, today's date is 29-01-09 but I want it to show 29 January 2009.

I can't figure out what to change to get the proper date format. I do want the format as dd-mm-yyyy but I want the month to be January not 01.

I'm using Windows XP home edition SP3.





--
JD..
.

Relevant Pages

  • Re: Number formats inconsistent
    ... Excel picks this up from a windows setting: ... change the negative currency format to show 's. ... We run Office 2003 on a Citrix terminal server. ... We tried changing the international settings on the server (stored outside ...
    (microsoft.public.excel.setup)
  • Re: leading zeroes on report date
    ... Open the Windows Control Panel. ... To set the Format property of the text box on your report in Access: ... reset a windows regional setting to make short date ... > I don't know how to find or set windows regional settings. ...
    (microsoft.public.access.formscoding)
  • Re: formatting of row depending on cell value
    ... Depends upon your short date format in Windows settings. ... Gord Dibben  MS Excel MVP ...
    (microsoft.public.excel.newusers)
  • Re: Adaptec AHA-2940AU vs AHA-1530P
    ... 1/ Under windows, run the device manager and look for the scsi drive. ... settings and verify that the "init 13 unit" option is turned on. ... 2/ Drop into a DOS box and run Fdisk from there. ... reboot into windows and format using "My computer" ...
    (comp.periphs.scsi)
  • Re: Date Function
    ... I think it's a windows setting that's different. ... On winxp, on the regional Options tab, click customize, then date tab. ... Check the long date format for each pc. ...
    (microsoft.public.excel)