Home » Category » Microsoft Excel

Microsoft Excel: zip code redux

205| Thu, 22 May 2008 23:21:00 GMT| anonymous| Comments (1)
This post pertains to formatting difficutlies when importing the zip field from an Excel spreadsheet that's using the zip format.

Dave Peterson wrote:

>After you select your Excel file as a data source, you should see a
>'Confirm Data Source' dialog box. From that list, choose 'MS Excel
>Worksheets via DDE (*.xls)', and your formatting will be retained.

I'm not getting any dialogue boxes where I can choose this option when I choose an Excel sheet as my source. It sounds like something I can make good use of. Dave, anyone else: what I'm I missing.

tj

Keywords & Tags: zip, code, redux, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495088/
 
«« Prev - Next »» 1 helpful answers below.
I responded in the original thread.

tjtjjtjt wrote:
> This post pertains to formatting difficutlies when importing the zip field from an Excel spreadsheet that's using the zip format.
> Dave Peterson wrote:
> >After you select your Excel file as a data source, you should see a
> >'Confirm Data Source' dialog box. From that list, choose 'MS Excel
> >Worksheets via DDE (*.xls)', and your formatting will be retained.
> I'm not getting any dialogue boxes where I can choose this option when I choose an Excel sheet as my source. It sounds like something I can make good use of. Dave, anyone else: what I'm I missing.
> tj
--

Dave Peterson
ec35720...msn.com

dave | Thu, 22 May 2008 23:22:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories