If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2002 SP3 CSV Format Cell 'Special' Leading Zero
Excel 2002 SP3, CSV File, Format Cell 'Special' for Zip
Code Leading Zero does not work. Is there any way to maintain the Zip Code Leading Zero (New England States) in a CSV File? I have tried Format 'Special' and 'Text' and have found the only solution to be to place a leading ' with each zip code. This is not a very practical solution. Is this a configuration problem, a bug, or a limitation of the CSV file? Thanks, William |
#2
|
|||
|
|||
Excel 2002 SP3 CSV Format Cell 'Special' Leading Zero
Hi
you may use an adjacent cell with a formula for this. e.g. enter in B1 =TEXT(A1,"0000") or something similar according to your zip code format -- Regards Frank Kabel Frankfurt, Germany William McKitterick wrote: Excel 2002 SP3, CSV File, Format Cell 'Special' for Zip Code Leading Zero does not work. Is there any way to maintain the Zip Code Leading Zero (New England States) in a CSV File? I have tried Format 'Special' and 'Text' and have found the only solution to be to place a leading ' with each zip code. This is not a very practical solution. Is this a configuration problem, a bug, or a limitation of the CSV file? Thanks, William |
Thread Tools | |
Display Modes | |
|
|