Home » Category » Microsoft Excel

Microsoft Excel: Zip Codes 5 digits only

205| Thu, 22 May 2008 22:48:00 GMT| anonymous| Comments (2)
Is there a way to change zip codes in a spreadsheet to only display 5 digits?

Keywords & Tags: zip, codes, digits, only, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495103/
 
«« Prev - Next »» 2 helpful answers below.
Hi,

Use custom cell format 00000. This will add leading zeros, if the cod
is shorter than 5 digits.
- Asse
--
Message posted from http://www.ExcelForum.com

jazzer | Thu, 22 May 2008 22:50:00 GMT |

=LEFT(zipcode,5) will strip off the extended codes.

Jerry

anonymous...discussions.microsoft.com wrote:

> Is there a way to change zip codes in a spreadsheet to
> only display 5 digits?

jerry | Thu, 22 May 2008 22:51:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories