Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: excel format txt same as type general

    I am in the process of exporting an excel file from access. Is text format the same as type general? I wanted to so that I don't have to change all the collumns that were exported as type "text" to "general".


  2. #2
    Join Date
    Jan 2004
    Aberdeen, Scotland
    There is a difference, Numbers set up in the text format will be treated as text whereas in the general format numbers are numbers(unless specified as text with ' ) and text is text, Excel tends to be leaniant with data types so you should be ok with leaving everything as general,
    I only change the format if i want to force the data i have into a specific type i.e. 2 decimal places etc.


Posting Permissions

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