Using zero's for the first number in excell collumns
I want to create a column for the zipcodes in a mailing list and some of them
have zero's as the first number. the formatting won't let me use zeros as the first number in a collumn. how do i fix this? |
Using zero's for the first number in excell collumns
try format-cells-number-special-zip code
"djc256" wrote: I want to create a column for the zipcodes in a mailing list and some of them have zero's as the first number. the formatting won't let me use zeros as the first number in a collumn. how do i fix this? |
Using zero's for the first number in excell collumns
Since the column is dedicated to zip codes, XL has a built in format you can
use: <Format <Cells <Number tab, and click on "Special". Gives you 2 choices: Zip Code & Zip Code+4 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "djc256" wrote in message ... I want to create a column for the zipcodes in a mailing list and some of them have zero's as the first number. the formatting won't let me use zeros as the first number in a collumn. how do i fix this? |
Using zero's for the first number in excell collumns
Pre-format the column as Text or preface your zipcodes with an apostrophe which
will be visible only in the formula bar. Gord Dibben MS Excel MVP On Tue, 11 Sep 2007 08:48:02 -0700, djc256 wrote: I want to create a column for the zipcodes in a mailing list and some of them have zero's as the first number. the formatting won't let me use zeros as the first number in a collumn. how do i fix this? |
Using zero's for the first number in excell collumns
You can try either
Format|Cells|Number tab|Special which allow sfor zip codes or zip codes + 4. OR (this is my preference as it does both) Format|Cells|Number tab|Custom category [99999]00000-0000;00000 -- HTH... Jim Thomlinson "bj" wrote: try format-cells-number-special-zip code "djc256" wrote: I want to create a column for the zipcodes in a mailing list and some of them have zero's as the first number. the formatting won't let me use zeros as the first number in a collumn. how do i fix this? |
Using zero's for the first number in excell collumns
"bj" wrote: try format-cells-number-special-zip code "djc256" wrote: I want to create a column for the zipcodes in a mailing list and some of them have zero's as the first number. the formatting won't let me use zeros as the first number in a collumn. how do i fix this? thanks! |
All times are GMT +1. The time now is 02:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com