ExcelBanter - How do I print preceding zeros in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I print preceding zeros in excel? (https://www.excelbanter.com/excel-worksheet-functions/170966-how-do-i-print-preceding-zeros-excel.html)

Fred DePazza

How do I print preceding zeros in excel?

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

Lars-Åke Aspelin

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

Tore Geir Kristiansen

How do I print preceding zeros in excel?

"Fred DePazza" wrote:

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

All times are GMT +1. The time now is 10:07 AM.