----- Original Message ----- From: "Dan Lewis" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, August 21, 2006 7:00 PM Subject: Re: [users] Concatenate a string in Calc
<snip> > 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.) Being English I didn't know calc understood zip codes in this way - our "post codes" are completely different: alphanumeric and variable length. Thanks for the tip. Harold Fuchs London England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
