Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dates using Regional Options
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VBA to temporarily bypass regional options | Excel Programming | |||
Regional options support for currency | Excel Programming | |||
Regional options support question | Excel Programming | |||
Problems with Excel Horizontal arrays with regional options using. | Excel Discussion (Misc queries) | |||
Regional Options and Decimal symbol from VBA | Excel Programming |