Re: [LUG] OO spreadsheet and dates

[Henry Bremridge <henry.bremridge@xxxxxxxxx>]

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


-- 
Henry
Photocopies or faxes of my signature are not binding. 
This email has been signed with an electronic signature in accordance with 
subsection 7(3) of the Electronic Communications Act 2000.
Digital Key Signature: GPG RSA 0xFB447AA1 
Sat Nov 13 12:56:51 GMT 2010

Attachment: signature.asc
Description: Digital signature

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq