Or, you can format the cell as "-01234"
without the quotes, or create a user format "00000" again without the
quotes. It will automatically insert enough leading zeros to produce a
five digit zip code.
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
|
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
