View Full Version : Help: How to get date input in specific syntax
yurble_vn
03-17-2008, 09:21 PM
Hi All,
You all may know, in some country the date format is different to English style. For example, in Vietnam, we note date like: dd/mm/yyyy not mm/dd/yyyy
But with excel, it just understand date like: mm/dd/yyyy
Is there anyway to get excel understand date when I input: dd/mm/yyyy?
Thanks in advance
mdmackillop
03-18-2008, 12:42 AM
How are your requirements set in in Control Panel/Regional & Language Settings?
Bob Phillips
03-18-2008, 02:09 AM
Excel understands many date formats, as a date is just a number since 1st Jan 1900, what you see on screen is just a presentational layer, and that can be formatted (almost) however you like. VBA is a bit trickier as VBA works with US style dates.
Tell us the specific problem yu are getting.
yurble_vn
03-18-2008, 07:47 AM
Thanks all,
FYI, I input
18/03/08 in cell A1 --> excel keep unchange
03/18/07 in cell B1 --> excel understand and change it to 3/18/07
make a subtraction: C1=A1-B1 ---> return value is: #VALUE!
SO, excel just understand the B1 as date, but not A1
What I mean in the above post is the input syntax. Excel force to input date under mm/dd/yy. If not, it wont be able to understand this as date type.
It there anyway to change?
yurble_vn
03-18-2008, 07:54 AM
Thanksmdmackillop (http://vbaexpress.com/forum/member.php?u=87)
You right,
But after this, can I conclude that this depends totally on machine. And can not customize in a particular excel file?
THanks
mdmackillop
03-18-2008, 08:43 AM
Cells can be custom formatted to any acceptable format. If there is a danger of confusion, maybe you could use "d mmm yy" as your Short Date.
mdmackillop
03-18-2008, 10:55 AM
I find that 03/18/07 is not recognised as a date (nor would I expect it to be)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.