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".
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.