Mister Sam
New Member
- Joined
- Nov 26, 2017
- Messages
- 1
Dear all,
I have created an Excel 2010 spreadsheet with several columns for dates. I intended the spreadsheet to use dates following the dd/mm/yyyy format, and as long as I open the spreadsheet on my pc the dd/mm/yyyy format works fine. Entering dates using the mm/dd/yyyy format results in an error message for dates like 10/31/2017 (as I intended).
However I found out from other users using the spreadsheet that they cannot enter dates in the dd/mm/yyyy format, but can enter dates using mm/dd/yyyy . In case they enter a date like 31/10/2017 they will get an error message. I would like a uniform dd/mm/yyyy format for all users using this spreadsheet to avoid any confusion with multiple date format being used simultaneously, additionally many of the users are not familiar with the American mm/dd/yyyy format.
I checked the date settings for the date columns under the format cell options; currently dd-mm-yyyy is selected , with Armenian as the locale option. The Armenian locale is not marked with an asterisk (*), which in my understanding means that the date format should not change even for users who use different settings.
Let me know if you need more information and thank you in advance for your help.
I have created an Excel 2010 spreadsheet with several columns for dates. I intended the spreadsheet to use dates following the dd/mm/yyyy format, and as long as I open the spreadsheet on my pc the dd/mm/yyyy format works fine. Entering dates using the mm/dd/yyyy format results in an error message for dates like 10/31/2017 (as I intended).
However I found out from other users using the spreadsheet that they cannot enter dates in the dd/mm/yyyy format, but can enter dates using mm/dd/yyyy . In case they enter a date like 31/10/2017 they will get an error message. I would like a uniform dd/mm/yyyy format for all users using this spreadsheet to avoid any confusion with multiple date format being used simultaneously, additionally many of the users are not familiar with the American mm/dd/yyyy format.
I checked the date settings for the date columns under the format cell options; currently dd-mm-yyyy is selected , with Armenian as the locale option. The Armenian locale is not marked with an asterisk (*), which in my understanding means that the date format should not change even for users who use different settings.
Let me know if you need more information and thank you in advance for your help.