[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On Sat, 2010-11-13 at 12:57 +0000, Henry Bremridge wrote: > On Sat, Nov 13, 2010 at 12:20:16PM +0000, Eion MacDonald wrote: > > > Dates OK, but saved as 'number' format in column one. Reinserted on new > > sheet and then date column formatted to date format not number gives > > correct dates. > > > > FWIW (took me some time to find the solution on the web) but to convert > text to numbers | dates > > Search .* > Replace & > Use Regular Expressions > Search Values > > Or, when importing the csv file; - in the Text Import dialogue, make sure "Other Options" - "Quoted field as text" is not checked, then - select the dates column, and choose Column Type "Date (YMD)" That should format the column as dates according to the default for your locale. Phil -- The Mailing List for the Devon & Cornwall LUG http://mailman.dclug.org.uk/listinfo/list FAQ: http://www.dcglug.org.uk/listfaq