•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
"Hardcoded" date format for global template
Hi there,
I'm currently creating a template for timesheets in Excel and facing an issue with date conversion. The target system only accept the date in the format "dd/mm/yyyy". I tried several ways in data formatting, but depending on the regional settings of the user the date always changes to system settings. My last failed attempt was to set the custom cell format to "[$-en-GB]dd/mm/yyyy", but it didnt work.
The file must remain in xlsx and I cannot use macros. Is there a way to hardcode the date format so that it only allows "dd/mm/yyyy" and does not default to system settings?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#date format
#dd/mm/yyyy
#Excel
#date conversion