day first then month?

slim · May 21st, 2002, 02:08 PM

I have a line in VBA as follows

activecell.value = date

but because xl is american it puts the month first then the day - I want it the other way around.

I can see in help that there is an xlDateOrder function but I don't know how to put it into the code can anyone help.

Tommy Bak · May 21st, 2002, 02:21 PM

Hi
1. You could choose to alter regional/international setting / date which describes what way all window programs should display dates. Set it to dd-mm-yyyy.

2. You can format the cell to dd-mm-yyyy
Selection.NumberFormat = "m/d/yyyy"
regards Tommy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 02:08 PM	#1
slim New Member Join Date: Feb 2002 Posts: 42	I have a line in VBA as follows activecell.value = date but because xl is american it puts the month first then the day - I want it the other way around. I can see in help that there is an xlDateOrder function but I don't know how to put it into the code can anyone help.

May 21st, 2002, 02:21 PM	#2
Tommy Bak Board Regular Join Date: Feb 2002 Location: Guderup, Denmark Posts: 287	Hi 1. You could choose to alter regional/international setting / date which describes what way all window programs should display dates. Set it to dd-mm-yyyy. 2. You can format the cell to dd-mm-yyyy Selection.NumberFormat = "m/d/yyyy" regards Tommy