Trouble with german / english dateformatting

A

Alex

Hi,
I have some trouble with formatting a datecolumn in Excel. At first I
export the datefields from a SQL-Database (without problems!). The
exported columns look like this:
24.04.2005 00:00:00
Afterwards I'm trying to format the date like DD MMM YYYY (e.g. 24 Apr
2005). This works fine... but the abbreviations (shortcuts) of the
months are always german. I need the english version. For example:
German: Okt / English: Oct
German: Mrz / English: Mar
German: Dez / English: Dec
I already tried
System.Threading.Thread.CurrentThread.CurrentCulture =
System.Globalization.CultureInfo.CreateSpecificCulture("en-US")
but it seems to have no effect.

I'm using MS Visual Studio 2003 with MS Excel 9.0 Object Library.
I'm having MS Excel 2000 installed on my machine.
Here's the code I'm using (only the relevant part):

==================================================================='Set
CultureInfo
System.Threading.Thread.CurrentThread.CurrentCulture =
System.Globalization.CultureInfo.CreateSpecificCulture("en-US")

Dim xlApp As New Excel.Application
Dim xlBook As Excel.Workbook

xlApp.Visible = False

'Open Workbook
xlBook = xlApp.Workbooks.Open("C:\Test.xls")


xlBook.Worksheets("Test").columns("A:A").Select()

xlApp.Selection.Numberformat = "DD MMM YYYY"


'Save Workbook
xlBook.Save()

'Quit excel
xlBook.Close(SaveChanges:=True)
xlApp.Quit()
xlBook = Nothing
xlApp = Nothing
===================================================================


Hopefuly someone has some experience in this. Thanks in advance

Cheers Alex
 
T

Tom Ogilvy

I think that is governed by the regional settings in Windows. I don't think
you can change it for a specific worksheet or workbook and still keep it
stored as a date - you would have to format it in code and place it as a
string.
 
P

Patrick Molloy

I think this is controlled by your Regional settings in control panel.??
 
A

Alex

Hey

thanks a lot for your quick responses. Actually these settings are the
key! If I change the "Region- and Language Options" to english (US)
the dateformat is correct. I just hoped that there would be a
workaround or something. But probably this is the only solution.
Maybe I have to do some programming to check the content for e.g. Dez,
Okt, etc. and replace it with Dec, Oct and so on. This will make my
application slow but it should work.

Thanks again!

Cheers Alex
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top