|
I was working on a google spreadsheet for a while, around 30-40 people were entering data to there and using it as a remote database. One day, while performing maintenance on that spreadsheet, I saw some dates entered in different format. Then later on, I realized that more than half of them were in different formats, totalling around at least 4 different formats.
Had to purge some of the data, and adjust the rest after asking people which format they use in their country. Wish we had global variables for all of these units, but well, what can you do :P
|