Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

download to excel

Status
Not open for further replies.
cf2001

cf2001

Programmer
Apr 3, 2001
10
US
I'm trying to download a dataset from access into a comma or text-delimited file into excel. I also need to preserve the leading zero number for a particular field. somehow, when downloaded and opened in excel it strips the leading zero.
 
Sort by date Sort by votes
In order for Excel to not remove the leading 0, it needs to read the field as something other than a number. If you append a string to the beginning or end like a No Break Space(ie " 00123"), then Excel will read the field as a string instead of a number. - tleish
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LonnieJohnson
  • Locked
  • Question
Downloading Dreamweaver
Replies
0
Views
289
LonnieJohnson
LonnieJohnson
RosieGp
  • Locked
  • Question
How to read string of 0s and 1s 1
Replies
3
Views
716
LyndonOHRC
LyndonOHRC
Mike Lewis
  • Locked
  • Question
Using Dreamweaver to maintain a site not created in Dreamweaver
Replies
2
Views
696
Mike Lewis
Mike Lewis
lollieleaver
  • Locked
  • Question
Dreamweaver CS4 - how can I make an Access database downloadable from my site?
Replies
2
Views
249
lollieleaver
lollieleaver
lwfg
  • Locked
  • Question
getting form values from ColdFusion programn to asp.net program
Replies
2
Views
300
LyndonOHRC
LyndonOHRC

Part and Inventory Search

Sponsor

Back
Top