inputbox date format - help!

[Damian1]

hi,

I have a macro that prompts the user to enter a date in when they open the workbook, and then the date is entered into a cell within the workbook. I am prompting the user to enter the date in the dd/mm/yyyy format, which they do, but it then comes up as a mm/dd/yyyy format in the cell! Is there a way around this?

thanks.

 

[Norie]

How are you placing the date in the cell?

How is the cell formatted?

If you don't format a cell, then enter a date in it Excel will use the default date format for the cell.