Dan Lewis wrote:
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
Thanks, Dan, that's a great suggestion, and I'll do it. I also found I
could re-open/paste the data with a pre-formatted field (as text) and it
left the leading zero. But... I still want to know why I can't get the
Concatenate function to work right for me.
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
