day first then month?

slim · May 21st, 2002, 02:09 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.

Al Chara · May 21st, 2002, 02:21 PM

How does this work for you:
ActiveCell.Value = Format(Date, "dd/mm/yyyy")

May 21st, 2002, 02:21 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	How does this work for you: ActiveCell.Value = Format(Date, "dd/mm/yyyy") __________________ Kind regards, Al Chara

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

May 21st, 2002, 02:09 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.