View Single Post
  #2   Report Post  
Phillycheese5
 
Posts: n/a
Default Newbie - Need help with zipcode format- no options for cell


Not sure exactly what you're trying to do with the zip codes....but
generally the issue is that the first zero doesn't stay after you type
it in (or import). If you highlight an area, use the "format" menu,
select "cells" and then on the "number" tab, select "text" to preserve
all characters you type, including zero. If you're importing, then you
need to specify the column to be imported as text.
Hope this helps,
Phillycheese


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=479197