|
 |
asp_web_howto thread: Help with data types in Excel Worksheet using ASP
Message #1 by "Christopher Cote" <chrscote@9...> on Fri, 6 Dec 2002 17:59:49
|
|
I am trying to display data from a query in an Excel spreadsheet. This
query includes data for name, address, city, state and zip code. The
problem I'm having is that when I try to display a zip code that begins
with a zero, the leading zero is taken off. Does anyone know how to get
the data to appear correctly?
Chris
Message #2 by "TomMallard" <mallard@s...> on Fri, 6 Dec 2002 20:37:25 -0800
|
|
Open the worksheet and right-click the column and format cells, special,
choose your type of zip code.
tom mallard
seattle
-----Original Message-----
From: Christopher Cote [mailto:chrscote@9...]
Sent: Friday, December 06, 2002 6:00 PM
To: ASP Web HowTo
Subject: [asp_web_howto] Help with data types in Excel Worksheet using
ASP
I am trying to display data from a query in an Excel spreadsheet. This
query includes data for name, address, city, state and zip code. The
problem I'm having is that when I try to display a zip code that begins
with a zero, the leading zero is taken off. Does anyone know how to get
the data to appear correctly?
Chris
|
|
|
View Cart
