On 9 Jul 2008 at 17:08, Brian Barker wrote: .... > Since you have text values in the cells, converting them to numbers > is probably going in the wrong direction. Instead, create a new > column with the values actually as you wish to see them > exported. One way to do this would be: > =LEFT(x;3)&"."&MID(x;4;3)&"."&RIGHT(x;4) > This takes the leftmost three characters, the three central > characters starting at character four, and the rightmost four > characters, and concatenates them with the two dots in between. > > This column will output to CSV as you need.
I missed the OP's note that the fields were quoted text not numbers - apologies. Brian's way will obviously work - but needs in an extra column, and hence a likely extra field in the output. I don't see anything in the save as csv dialogue that allows just selected columns to be saved - is it there? Otherwise, maybe the OP could convert all the quoted numeric strings to actual numbers in a new column using decimal(), then delete the old column and format as I described elsewhere. It depends on exactly what the OP wants - there's obviously a fair bit of choice! -- Permission for this mail to be processed by any third party in connection with marketing or advertising purposes is hereby explicitly denied. http://www.scottsonline.org.uk lists incoming sites blocked because of spam [EMAIL PROTECTED] Mike Scott, Harlow, Essex, England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
