Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Wrong In Excel

Status
Not open for further replies.
DavCl

DavCl

Programmer
Oct 12, 2010
3
GB
Could anyone please help
I have built a form that inputs information into Excel one of the fields is a date format "d/m/yy"
When it inputs this into Excel it imports the date as "m/d/yy"
Any help appreciated
 
Sort by date Sort by votes
Hi,

faq68-5827

The take away is that Excel assumes that your date is m/d, so ENTER it that way in the sheet.

FORMAT your date cells to DISPLAY d/m.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
622
remeng
remeng
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
236
sal21
sal21
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
385
huiettcm
huiettcm
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
349
combo
combo
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
2K
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top