inputbox date format - help!

Damian1

New Member
Joined
Nov 22, 2005
Messages
1
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.
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,028
Messages
5,569,741
Members
412,289
Latest member
Kingchaos64
Top