excelgal2016
New Member
- Joined
- Dec 14, 2016
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
Is there a way for the Workday Worksheets to reflect the user system settings of the date format? Currently our report administrator had "hard formatted" the date format to:
mm/dd/yyyy
However, we have a mixture of global employees, some of them have date format
dd/mm/yyyy.
This creates a problem, when we are copying > pasting the data into Excel.
Any ideas?
I know there is a workaround by manually changing the settings File > Settings > Locale. Alternatively, is there a way to making the Locale default to User WD setting?
I'd appreciate any help, WD is not my domain, Excel forever![Wink ;) ;)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
mm/dd/yyyy
However, we have a mixture of global employees, some of them have date format
dd/mm/yyyy.
This creates a problem, when we are copying > pasting the data into Excel.
Any ideas?
I know there is a workaround by manually changing the settings File > Settings > Locale. Alternatively, is there a way to making the Locale default to User WD setting?
I'd appreciate any help, WD is not my domain, Excel forever