Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Girls Club
 
Posts: n/a
Default Microsoft Excel will not show a "zero" as the first digit spot.

We have Windows XP. I have created a mailing label list in Microsoft Excel.
In the zip code column, a zero is the first digit. However, when printed out,
the zero does not appear, only the 4 digits after that. How do I get the
program to recognize and print the zero?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Microsoft Excel will not show a "zero" as the first digit spot.

Format as 00000

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Girls Club" <Girls wrote in message
...
We have Windows XP. I have created a mailing label list in Microsoft

Excel.
In the zip code column, a zero is the first digit. However, when printed

out,
the zero does not appear, only the 4 digits after that. How do I get the
program to recognize and print the zero?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Microsoft Excel 2003 and Hyperion Retrieve with Excel 2000. Juan Angel Excel Discussion (Misc queries) 1 June 21st 05 09:55 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Hints And Tips For New Posters In The Excel Newsgroups Gary Brown Excel Worksheet Functions 0 April 15th 05 05:47 PM
How do i copy columns of data in notepad into microsoft excel? JP New Users to Excel 2 February 10th 05 09:47 PM
UDF and Calculation tree Ken Wright Links and Linking in Excel 1 February 6th 05 04:58 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"