ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   how do i format zip codes that lead with a "0" in excel for a wor. (https://www.excelbanter.com/setting-up-configuration-excel/11410-how-do-i-format-zip-codes-lead-%220%22-excel-wor.html)

execl formatting

how do i format zip codes that lead with a "0" in excel for a wor.
 
zip codes with leading zeros in excel won't merge in word mail merge

Nick Hodge

Prefix with a single apostrophe
(')

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"execl formatting" <execl
wrote in
message ...
zip codes with leading zeros in excel won't merge in word mail merge





All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com