At 14:29 09/07/2008 +0200, Al Noname wrote:
I have a case where numbers are used in a text format of xx
(10 characters), that should be converted to xxx.xxx. (10
characters in groups of 3, 3 and 4 separated by a dot). The
characters should be text, but using numbers; e.g. 001.002.0
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:
> =L
mike scott wrote:
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
At 19:05 09/07/2008 +0100, Mike Scott wrote:
[...]
I don't see anything in the save as csv dialogue that allows just
selected columns to be saved - is it there?
No, I don't think it is. Hiding an unwanted column doesn't
help. Possible workarounds are:
o copying the formatted values back to
mike scott:
> I missed the OP's note that the fields were quoted text not numbers -
> apologies.
They have leading zeros that are significant, I'd classify that as
text. Also the only reason that the separators are not present is a
size constraint in the source database, another indicator that the