entering date

[lezawang]

Hi
My computer date format as following dd/mm/yyyy (as per the date below the clock on my computer).
I entered this date in an excel cell: 2019/09/08 (09 is sept). To my surprise, excel converted this date to the following

08/09/2019

Why is that?

I thought excel should not accept 2019/09/08 as a date and keep it as it is (to the left hand side of the cell) because it should be considered as string not number, since I did not follow the format of the computer date.

Thank you very much

 

[Rick Rothstein]

Hi
My computer date format as following dd/mm/yyyy (as per the date below the clock on my computer).
I entered this date in an excel cell: 2019/09/08 (09 is sept). To my surprise, excel converted this date to the following

08/09/2019

Why is that?

I am not sure why it chose that order given your computer's setting; however, if you wish to enter dates in YEAR, MONTH, DAY order, use dashes instead of slashes and I think Excel will convert it correctly. For example...

2019-09-08

 

[mohadin]

Hi, What abuot

Cells(2, 3) = Date
Cells(2, 3).NumberFormat = "yyyy/mm/dd"

 

[Fluff]

Excel is simply trying to be "helpful" it recognises 2019/09/08 as a date & converts as such.
To stop that happening, change the cell format to text before entering the date, or put an apostrophe as the first character.

 

[mohadin]

Excel is simply trying to be "helpful" it recognises 2019/09/08 as a date & converts as such.
To stop that happening, change the cell format to text before entering the date, or put an apostrophe as the first character.

If so, why not:
From the format cell > Custom > Type yyyy/mm/dd

 

[Fluff]

My take is that the OP wants the value to remain as a string, rather than be converted to a date.