4 Replies Latest reply: May 24, 2012 6:29 PM by WaynefromSA
WaynefromSA Level 1 (0 points)

I'm trying to import a csv file from my bank. Numbers automatically adds a "+" and "-" sign before all numbers. Numbers won't add the numbers with a + sign. How can I easily remove the + sign? It seems the delimiter in the csv file may be ", rather than , Thanks.


MacBook Pro, Mac OS X (10.7.4), Numbers 09 version 2.1 (436)
  • Jerrold Green1 Level 7 (29,960 points)

    Wayne,

     

    I don't believe that the plus sign came from Numbers. Except for a purposful application of a Custom Format, Numbers isn't going to add the plue sign. The minus sign is another issue. It's a perfectly acceptable part of the value and shouldn't cause a problem.

     

    If the plus sign came from the CSV file, which you seem to imply isn't the case, you would have to strip it out before submitting to Numbers.

     

    Jerry

  • WaynefromSA Level 1 (0 points)

    Jerrold, you're right. I've checked the CSV file & the plus sign is in there. I can strip it out but this is tedious. Interestingly, if I copy the numbers [with the plus sign] in Numbers & paste to Excel, the plus sign disappears. If I then copy the numbers in Excel and paste them back into Numbers, the plus sign is gone. This is easier than editing the CSV file. However, I'm wondering if Numbers has a filter of some sort that can be set to eliminate the plus sign appearing in the first place. Wayne

  • Jerrold Green1 Level 7 (29,960 points)

    Wayne,

     

    It would be easy in a text app like Pages to Find and Replace the plus signs away. Same in Numbers if you are sure you won't throw away any parts of formulas.

     

    Jerry

  • WaynefromSA Level 1 (0 points)

    Jerry,

     

    Great suggestion. It worked fine.

     

    Thanks.

     

    Wayne