G
Guest
I have a spreadsheet that has a column formated as general, but the numbers
in the column are right justified in some and left justified in others. If
the number has a space after the first 3 numbers it left justifies. If it
does not then it right justifies. This spreadsheet is downloaded from a
vendor in .xls format.
My problem is I am trying to import into Access and when it hits the numbers
that are left justified it gives me an import error.
Is there something in this spreadsheet that I can not find that is causing
this to act differently?
in the column are right justified in some and left justified in others. If
the number has a space after the first 3 numbers it left justifies. If it
does not then it right justifies. This spreadsheet is downloaded from a
vendor in .xls format.
My problem is I am trying to import into Access and when it hits the numbers
that are left justified it gives me an import error.
Is there something in this spreadsheet that I can not find that is causing
this to act differently?