Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Exclamation Unanswered: export to excel as text

    i have a field that looks like: 002/12
    when it is exported into excel, it is export as a number and therefore displayed as a calculated total.
    how do i export it so that it still looks like 002/12.

  2. #2
    Join Date
    May 2004
    Location
    Moscow, Russia
    Posts
    29
    export or copy / pastespecial ?

  3. #3
    Join Date
    May 2004
    Posts
    15
    In your Access database place a ' before the value and excel will recognize it as text. Access will not print out the '.

Posting Permissions

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