LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bea VanKampen
 
Posts: n/a
Default how do I enter a zipcode starting with a 0

i am typing a name list. Some of the zipcodes start with a 0 (east coast).
Excel doesn't show the 0 and shows only 4 digits. How do I get it to show the
0
 
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
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
how do i enter numbers starting with zero in excel achitsyerself Excel Discussion (Misc queries) 3 May 12th 05 08:21 PM
ENTER ONE VALUE, RETURN ANOTHER Sarah_Lecturer Excel Discussion (Misc queries) 6 April 13th 05 10:01 PM
"Enter" in Macros Desperate Excel Discussion (Misc queries) 4 February 26th 05 03:43 AM
How do you enter numbers in a fraction format ? (78/27) LBPerry Excel Discussion (Misc queries) 0 January 23rd 05 09:51 PM


All times are GMT +1. The time now is 02:35 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"