Results 1 to 3 of 3
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts
    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

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you use the Data-Import from Text, there is an option for trailing negatives.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,819
    Thanks
    133
    Thanked 480 Times in 457 Posts
    Hi Rory

    Brilliant!

    I had never noticed that option before!

    Many thanks indeed.
    You are a star.

    zeddy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •