Excel Macro - displays dates in USA format rather than dd/mm/yy. Can this be changed?

Question

Hi all

I just used the Excel Macro.

However it displays the dates in the spreadsheet in USA format, however I am in Australia and would like dates to be displayed as dd/mm/yy format.

The spreadsheet has the dates formated as dd/mm/yy - but it's not displayed that way in confluence.

Is there a way to fix this?

Thanking you in anticipation.

Pierre-Yves Sinou_fkh6fl · Answer

Can you point me where I can find this option in Confluence?

Laura Holton _ACE Manchester_ · Answer

Hi @Debbie Charles 👋

I've taken a quick look at this for you and it appears it is a common issue over the years for users. As mentioned by @Fabian Lim, I'd recommend voting for this ticket and watching for any further updates: https://jira.atlassian.com/browse/CONFSERVER-59312

I hope this helps but if you have any questions just ask away 😃

All the best,

Laura

Andy Gladstone · Answer

@Debbie Charles Date and time formats can be adjusted in the Settings under General Configuration -> Formatting and International Settings. That should change them throughout the system when you post dates.