Thread: How do I print preceding zeros in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lars-Åke Aspelin Lars-Åke Aspelin is offline
external usenet poster
  
Posts: 30
Default How do I print preceding zeros in excel?
On Fri, 28 Dec 2007 09:48:01 -0800, Fred DePazza <Fred
wrote:

In an address list I want to print the preceding zero in the zip code calumn

Use the special number format for zip code, see
http://pubs.logicalexpressions.com/p...cle.asp?ID=414

Hope this helps / Lars-Åke
Reply With QuoteReply With Quote