Hi All
I have a csv file that contains a column of ‘values’.
The ‘negative’ values have a format of xxxx.xxx-
So the ‘minus’ char is at the end, rather than the beginning.
When opened in Excel2010, the ‘negative’ values are treated as ‘text’ values, whereas the non-negative values are happily imported as ‘numeric’ values.
The csv datafile may contain 300,000 records.
So is there a quick way to ‘convert’ this data column when imported to Excel, as all numeric values?
Or do I have to create and copy a formula to test for the minus char, then get the number part etc etc.
Just asking.
zeddy
