handling -ve values

[#1]

The -ve values of a field when read , are being converted in this format , (123345) (i.e. encapsulated by brackets). So are excluded in aggregations.

How to load the fields having -ve values.?

Any help is appreciated.

Thanks.

[yblake]

may be TextBetween(fieldname,'(',')') can help you.

[#3 · Accepted solution]

I figured it out.Issue was with the file.The Cell which holds these values has no format.I changed it to 'General'.

Thanks.