Convert postcode to text

[David Ehmer]

Can anyone offer a way to convert a column of postcodes/zipcodes (currently
in general format) to text. Reason is to import these into a Word document
as part of a mail merge. Currently when imported they show up with a
decimal point and a zero after the number (eg. 4173.0) Manually changing
the column to text format doesn't appear to effect the merge. Only thing
that has worked is creating a new column and setting it to 'Text' format and
then re-entering the data. Once done they display in word as (eg. 4173)

There must be a better way!

Appreciate any suggestions.

Thanks
David

[cycling-rod]

Highlight the column of postcodes/zipcodes (currently
in general format) and change the format to text. Numbers such as 4173.0 will become 4173.