Walter A. March wrote:
CarlP wrote:
Harold Fuchs wrote:
----- 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)
<SNIP>
Hmmm. I see what you mean. It's fine in my case, as all zip codes
are 5 digits. But I can see some instances where one might always
want 2 leading zeros, no matter how many digits or "spaces" the
number takes up. Is there any option forthis other than hand-entering
the leading zeros in a field formatted as text?
<SNIP>
uh... that's sort of what your original formula will do.
If you can get =CONCATENATE("00";G3) to calculate, it will put two zeros
in front of the contents of G3 no matter how long G3's text is.
="00"&G3 also works
WalterAM
Well, that's what I'd have thought, but the formula didn't work. Now I
understand why, though, so my question is now moot. THanks for the
answer, though.
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
