Discussion on:

Message 38 of 81
1 Vote
+ -
#5, atomize
Great advices and many instructives comments !
Further to atomize, I split dates into separate columns of days, months, and years. Otherwise whenever changing country, dates are transformed into varied formats DDMM or MMDD or whatever. Import-export dates from text files further can be particularly troublesome. The trick to overcome Excel's automatic date formatting is arcane, I ended up atomizing the dates.
Posted by anhxang@...
27th Jun 2011