LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default The 0 is dropped in zip codes beginning w/zero (Excell)

Whenever I enter a zip code or birthdate (01/02 1943) begining with a zero in
Excell, the zero is dropped when I print a list. How can I ge the zero to
display at the beginning in these instances.
David (a dunce, I guess)
 
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
Macro Help replacing dropped zeros [email protected] Excel Discussion (Misc queries) 5 September 2nd 06 06:08 PM
Entering zip codes beginning with zero jacktar Excel Discussion (Misc queries) 2 August 29th 06 07:47 PM
Why does Excel, drop beginning zeros in zip codes on mailing label Kate Excel Discussion (Misc queries) 5 April 24th 06 01:17 AM
How do I get Excell to recognise 0 at the beginning of a number? The Wonder From Downunder Excel Discussion (Misc queries) 4 February 4th 06 11:57 AM
Dropped zeros when merging Kim Excel Discussion (Misc queries) 1 April 28th 05 09:06 PM


All times are GMT +1. The time now is 08:34 AM.

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

About Us

"It's about Microsoft Excel"