5-Digit Zip Code

[gymwrecker]

I have over2000 records and all of them have the "9-digit" Zip Code. How can I format them to show only the first five digits? Tried thru Format Cells / Number / Special, but didnt work... Please advise.

 

[Rick Rothstein]

Well, following ps1's advise, I use =left(a1,5) and each cell is now showing tha formula. The problem I'm having is that since I want to use a VLOOKUP function, the 5-digit zip codes are not showing, and therefore, the Vlookup is not working. How can I make each cell to show the 5-digit zip code instead of =left(a1,5)?

Did you see my question in Message #8?