|
I am currently working with MS Excel and VB code. I was given a set of code by a colleague. The code copies and pastes data from a number of files into a consolidated spreadsheet.
The problem is that when the data is copied all the dates are reformatted from the UK format (dd/mm/yyyy) to the US format (mm/dd/yyyy).
I have read your advise on how to sort this problem out using <%session.lcid = 2057%> What is the equivalent of this in Excel?
Please help me.
|
|
|
|
|
|
|
// |