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

[Debbie Charles]

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. 

[Fabian Lim]

Hi @Debbie Charles

There is no workaround for this. However, you can vote for this feature: https://jira.atlassian.com/browse/CONFSERVER-59312

Regards

[Laura Holton _ACE Rotterdam_]

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]

@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.

[Pierre-Yves Sinou]

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