Currently Being ModeratedMay 24, 2012 8:26 AM (in response to WaynefromSA)
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.
Currently Being ModeratedMay 24, 2012 5:00 PM (in response to Jerrold Green1)
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
Currently Being ModeratedMay 24, 2012 6:10 PM (in response to WaynefromSA)
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.
Currently Being ModeratedMay 24, 2012 6:29 PM (in response to Jerrold Green1)
Great suggestion. It worked fine.