Zip code: eliminating the last 4 digits

[polska2180]

Okay when I run a report from my system I get zip codes that are as fallows

65014
65184
35489
648799648
65489
634558987
61354

Anywasy some of the have the 4 digits at the end that give me problems. Is there a way that i could quickly get rid of the 4 digits at the end and keep the original 5 so that all would read.

65014
65184
35489
64879
65489
63455
61354

 

[polska2180]

thanks....


boy do i feel like a dumba**

 

[TheNoocH]

why not just use =left(a1,5)

It creates a separate column.

gotcha...didn't read into it that far...