+ Reply to Thread
Results 1 to 2 of 2

Saving individual sheets as .csv isn't saving plus symbols at the start of cells..

  1. #1
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    Saving individual sheets as .csv isn't saving plus symbols at the start of cells..

    Hey Guys,

    Really simple error to spot/understand basically whenever I save all my individual sheets as csv files it fails to save the + symbol at the start of each cell...

    See the attachment, run it (outputs the csv to C:\ folder) and compare.

    Anyone know how to get around this?
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Saving individual sheets as .csv isn't saving plus symbols at the start of cells..

    That's not technically correct. If you open the csv file with notepad, you'll see that the plus-signs are there.
    The problem arises when you open the file with Excel in the normal way. Excel interprets the plus-signed numbers as numeric...and discards the plus-sign.

    Try this:
    Data.From_text...Select your csv file
    ...Check: Delimited.....click: Next
    ...Check: comma........click: Next
    ...Select the last column....check: Text
    ...Click: Finish

    When imported as text, the final column retains the leading plus-sign
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Saving Individual Tabs as Files
    By DonHuff in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-06-2015, 12:18 PM
  2. dynamically saving excel tabs to individual .csv files
    By xcelnovice101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2012, 02:12 AM
  3. New sheet name extracted from various cells, sorting sheets, saving new workbook
    By Luccin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2010, 05:51 AM
  4. how to close a workbook without saving a individual worksheet?
    By vjarowdy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2007, 05:44 PM
  5. Saving worksheets within workbooks as individual files
    By Colin Hayes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2006, 01:55 PM

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