date

ilspensoroso · May 9th, 2002, 10:25 AM

I am using an inputbox in vba to insert a date in an excel sheet as part of a program. My Regional settings are dd/mm/yy. The column in excel is formatted dd/mm/yy but when I use the input box as dd/mm/yy the date appears on the sheet as mm/dd/yy. If it is entered as 10/May/02 it will return 10/05/02. But entered as 10/05/02 will return 5/10/02.

You can make a hell of heaven or a heaven of hell.

Mark W. · May 9th, 2002, 11:12 AM

Quote:

...My Regional settings are dd/mm/yy.
...But entered as 10/05/02 will return 5/10/02.

I cannot reproduce these results.

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

May 9th, 2002, 10:25 AM	#1
ilspensoroso Board Regular Join Date: May 2002 Posts: 53	I am using an inputbox in vba to insert a date in an excel sheet as part of a program. My Regional settings are dd/mm/yy. The column in excel is formatted dd/mm/yy but when I use the input box as dd/mm/yy the date appears on the sheet as mm/dd/yy. If it is entered as 10/May/02 it will return 10/05/02. But entered as 10/05/02 will return 5/10/02. You can make a hell of heaven or a heaven of hell.