Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2010

    Unanswered: Convert Data type

    In one of the column of excel, the data contains data with numeric and some data with characters. How can I convert the data type of the column to Text.

    I tried to use the DigDB AddIn (Convert Excel Data Types - from Text to Number/Date (General), vice versa - Excel Tips & Add-ins) and now the AddIn in my PC has expired.

    I need to perform the similar task (to convert the data type to Text).


  2. #2
    Join Date
    Sep 2008
    London, UK

    If I understand your question correctly, select the column, right click | format, and choose the "Text" category.

Posting Permissions

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