Hi All,
I have recorded a macro to save each worksheet in my file to a separate CSV file (which I then upload to my accounting software). My problem is that when I run through the keystrokes manually I get UK format on the dates but if I run the same keystrokes in the recorded macro the dates could out in USA format and are rejected by my accounting software. The marco looks like this:
Please let me know how to tell Excel to use UK dates.Please Login or Register to view this content.
Kind regards,
Janine
Bookmarks