I have two groups of users entering data on identical spreadsheets -
one in Asia (using Regional Option of yyyy/mm/dd) and the other in
Australia (using dd/mm/yyyy). Both automatically load data into their
respective spreadsheets from the same csv file which contains dates in
dd/mm/yyyy format. My problem is how to manipulate dates on the
spreadsheet so that I end up with the same output format on both.
TIA, Dave