Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
All I had to do was put an apostrophe ' in front of the 0 and that
worked. The "0" printed but not the apostrophe. "Gary's Student" wrote in message ... Zip codes are a special format. Select a cell and then pull-down: Format Cells... Number Special and select Zip Code or Zip Code+4 as you prefer Then enter the data with a leading zero. Good Luck -- Gary's Student "J Mac" wrote: I just tried to print a Christmas list many of whom live in N.J. which has many zip codes that start with a zero. They don't print. This is with Office 2003. That has to be a fix for this. Any help please?? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
nine digit zip code won't print in mail merge | Excel Discussion (Misc queries) | |||
Change case...help please | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Code for Print Layout | Excel Discussion (Misc queries) | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |