Help: How to get date input in specific syntax

[yurble_vn]

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]

How are your requirements set in in Control Panel/Regional & Language Settings?

[Bob Phillips]

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]

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]

Thanksmdmackillop
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]

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]

I find that 03/18/07 is not recognised as a date (nor would I expect it to be)