4 Replies Latest reply on Feb 12, 2007 2:15 PM by insuractive

    Excel - Set the column data type

      I am trying to write a long number (ex: credit card number) to a spreadsheet column and excel is giving me the E+ bla bla error as it is trying to write it as number. My only chance to display it correctly, is to output it as string and the only way to achieve this is by pre-pending a 'string' character (ex: a space or   or a quote or whatever.)
      The problem is that the client doeasnt want any foreign character in the cell for he wouldnt have to search and replace thousanends of record. (They find it awkward! dont understand why, since this si done in one go. Anyway..)

      Is there any way I can instruct the excel that the long number is to be written as string?