Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Leading 0s (2000)

    I have a report in Access that I am using Office links to analyze it in Excel. When I bring the report into Excel, two number fields (that are defined as text) lose there leading 0s. Is there some way to bring over the fields the way they look in the Access Report?

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Leading 0s (2000)

    I had a similar problem with data I imported into Access from a big external database, via Excel. The only solution I found was to format the appropriate field(s) to display the leading zeros. Of course, my data was moving in the opposite direction. Not sure how to approach your situation....

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Leading 0s (2000)

    I don't think so. Excel is very persistent in trying to interpret data as numbers if possible. So you will have to apply the appropriate format in Excel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •