More zip + 4 problems
Dave Peterson: I did first copy a column of zip codes. The column has nine
digit numbers and five digit numbers. I pasted it into another worksheet, selected Format, Special, zip + 4. Nothing happens until I double click one of the cells and the format will change. The nine digit ones now display correctly but the five digit ones will appear as 0001-2345 rather than 12345. Is there any way around this? |
More zip + 4 problems
You don't want to use Zip+4 as your number format.
Try a custom format of Format|Cells|Number tab|Custom category [99999]00000-0000;00000 In that Type: box. dm wrote: Dave Peterson: I did first copy a column of zip codes. The column has nine digit numbers and five digit numbers. I pasted it into another worksheet, selected Format, Special, zip + 4. Nothing happens until I double click one of the cells and the format will change. The nine digit ones now display correctly but the five digit ones will appear as 0001-2345 rather than 12345. Is there any way around this? -- Dave Peterson |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com