Question

Locked

How to get the system short date format using macros in Excel?

By arunnc84 ·
Hi,
I am in the process of converting date to yyyy-mmm-dd format i.e 2007-JUN-05 format. The problem i am facing is i have a date in MM/DD/YYYY U.S format in my excel sheet now if i change my system regional settings to some other country which has short date format as DD/MM/YYYY here my conversion goes wrong i.e it gets converted to 2007-MAY-06. This has been breaking my head can you people help me regarding this.

Regards
Arun

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums