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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
