View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
cycling-rod
 
Posts: n/a
Default Convert postcode to text


Highlight the column of postcodes/zipcodes (currently
in general format) and change the format to text. Numbers such as
4173.0 will become 4173.


--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520
View this thread: http://www.excelforum.com/showthread...hreadid=503968