On Monday 21 August 2006 11:55 am, CarlP wrote:
> 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.
Why not just format the column for US Zip Codes in the first
place?
If you want just the first 5 digits, format the column (G) as
follows:
1) Category: Number
2) Go to the User defined box and replace what is there with five
zeros (0). Click the green arrow to the right of the box. This should
create a new Format: -01234.
3) Click OK.
If you are using 9 digits with a "-" between the first five and
the last four, this can also be done by reformating the column.
(The User Defined format would be 00000-0000.)
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
