----- Original Message -----
From: "CarlP" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, August 21, 2006 5:55 PM
Subject: [users] Concatenate a string in Calc
> Trying to add a leading zero on eastern US zip codes using the
> Concatenate function as follows:
>
> =CONCATENATE(0;G3)
> and
> =CONCATENATE("0";G3)
>
> where G3 is the column with zip codes. (The data was brought into a
> numeric field, hence the leading zero fell off.) But this only shows
> this formula in the cell, not the result. Note View Formulas is not
> checked in the Calc Options.
<snip>
1. Works for me on WinXP Pro/SP2 with OOo 2.0.3; which OS and OOo versions are
you using?
2. Are the codes all to display to the same number of digits? If so, you could
change the number format to include leading zeros by fixing the length of the
displayed data: select the column/row and then Format/Format Cells/Leading
Zeros. This is a bit misleading (IMHO). The number you enter determines the
width of the actual entry, *not* the number of leading zeros. So if you say 6,
then the value 1 will show as 000001 and the value 1234 will show as 001234.
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
