Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert postcode to text
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert postcode to text
Highlight the column of postcodes/zipcodes (currently in general format) and change the format to text. Numbers such as 4173.0 will become 4173. -- cycling-rod ------------------------------------------------------------------------ cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520 View this thread: http://www.excelforum.com/showthread...hreadid=503968 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert excel file into ASCII text file with alignment? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
How to convert columns of data to one column of text | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |