Date Format for days 01-12 are americanized

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Date Format for days 01-12 are americanized

FAQ

Thread Tools

Display Modes

09-07-2015, 07:05 PM

jcrennan

Windows 7 64bit Date Format for days 01-12 are americanized

Office 2010 64bit

Novice

Join Date: Sep 2015

Posts: 5

Quote:

Originally Posted by macropod

I think you'll find the serial value of the date being output by the userform is as per the dates displayed in the worksheet...

It looks like this could be the issue but is there a way to fix this, it seems anything days 1-12 come across as serial numbers but all other dates come across as a short date.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to count even exact date 90 days	redza	Excel	1	09-17-2013 03:36 AM
Date Field to add 10 Days to Current Date	Erbwon	Word	6	11-12-2012 06:17 PM
Set calendar alarm x days before end date	el_ja	Outlook	2	01-19-2012 10:09 AM
30+ days Variable Day Date Calculations via Fields	ztag	Word	2	01-06-2012 11:12 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 AM.