Skip to Content
Former Member
Mar 05, 2009 at 08:04 PM

Trailing Minus in Data file causing issues!


Hello Everyone,

I think there should be an easy solution to this but I can't figure out the syntax to make it work. My problem is in my data file some of my Amounts are in the file as 6785.28-. When I try to load the data file BPC does not like the trailing minus sign. If I open the file in Excel and use the text to Columns tool it fixes the amounts to be -6785.28. Is there anyway to accomplish this in BPC so users will not have to open the data file in excel and then resave it?

Thanks in advance!