Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Thanked 0 Times in 0 Posts

    Importing figures as Values, not text (2000/SP 0)

    I am importing figures from a CSV file. Excel thinks one of the fields is Text, when it's actually a number. How do I convert the cells back to being treated as numbers without having to use a function on each cell, i.e. how can I achieve this through formatting, not by having to use a function.

    Any help most appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Importing figures as Values, not text (2000/SP 0)

    Select the column with "text" cells.
    Menu option Data/Text to Columns.
    Click Finish.

    (Thanks to Jan Karel Pieterse for this neat trick)

Posting Permissions

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