Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Beta 2 chart problems | Charts and Charting in Excel | |||
Named range causing really weird problems - HELP | Excel Discussion (Misc queries) | |||
2 Excel Problems that have been bugging me! | Excel Discussion (Misc queries) | |||
Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
I'm getting mad - I'm having problems with EXCEL file name length | Excel Discussion (Misc queries) |