date and / or \

[lezawang]

Hi
I have tried to enter same date into 2 different computers. I noticed one computer accepted 1/1/2017 as a date but the second computer did not accept it and the date stayed in the left hand side of the cell. Why is that? Why one computer accepted 1\1\2017 and others not.

 

[Leith Ross]

Hello lezawang,

Time and Date separators vary by country. Here is list of valid date separators: / (slash), - (dash), . (period), and , (comma). A space may also be used.

The user's time and date along with several other system formatting options are set by the user's country setting. Application programs generally use the system settings as the default, but can change them.

 

[lezawang]

Thanks for your reply. Both computers win10, both in same country, both office 2010. not sure why really. and by the way , (comma) . (dot) are not acceptable by excel in date format. thanks

 

[FDibbins]

...and by the way , (comma) . (dot) are not acceptable by excel in date format. thanks

actually, they are (using Custom Formatting

[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][/tr]
[tr][td]

8​

[/td][td]

9/28/2017​

[/td][/tr]

[tr][td]

9​

[/td][td]

9.28.2017​

[/td][/tr]

[tr][td]

10​

[/td][td]

9,28,2017​

[/td][/tr]

[tr][td]

11​

[/td][td]

9 28 2017​

[/td][/tr]

[tr][td]

12​

[/td][td]

9 & 28 & 2017​

[/td][/tr]
[/table]

Something else to consider, Are the cells set to text format?