Results 1 to 19 of 19

Save number as text in txt format wo changing the format

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2005
    Posts
    8

    Save number as text in txt format wo changing the format

    In order to export an excel table into another program I first need to save the excel file as .txt. The .txt file can then be imported by the other program.

    First I however need to make excel understand that the value should be a text and not a value. I therefore format the number as text (0000150235) by adding "0000150235". After saving the file as .txt the format changes from "0000150235" to """0000150235""". I do however need the format in the .txt file to be "0000150235". Can anyone tell me how I can save "0000150235" as .txt and get the value "0000150235" in the .txt file.

    Thank you
    Last edited by Tysken; 03-01-2007 at 08:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1