Mix of numbers/letters in same column - Error exporting
 

Hi,
I've got a problem with using Excel 2003 data in other programmes (either
Access or BarTender label software), in the sense that it will not display
certain items of a particular column.
The 'Size' column of the worksheet consists of a mixture of numbers (8,10, .
.. 20) and letters (S,M,L,XL). When trying to import the data into other
programmes it recognises the numbers but leaves out the letters, ie returning
blank cells.

Is there a way that the mixed information can be formatted without me having
to list letters and numbers in separate columns?
(Format Cells either General, Number or Text hasn't worked)
Same problem occurs with a mixture of product codes, e.g. J2345es / 6789
(Tried saving the file as text and DBase, all of which didn't work)

Thanks for your input.

Malte

Mix of numbers/letters in same column - Error exporting
 

It depends on how you have setup Access, Whete the table column is set to
integer or text.

I only did a short course on Access and do not really know much more.

Maybe you could just use excel to configure you data..

see some of my stuff at:
http://www.geocities.com.excelmarksway



"Malte Sievers" wrote:

Hi,
I've got a problem with using Excel 2003 data in other programmes (either
Access or BarTender label software), in the sense that it will not display
certain items of a particular column.
The 'Size' column of the worksheet consists of a mixture of numbers (8,10, .
. 20) and letters (S,M,L,XL). When trying to import the data into other
programmes it recognises the numbers but leaves out the letters, ie returning
blank cells.

Is there a way that the mixed information can be formatted without me having
to list letters and numbers in separate columns?
(Format Cells either General, Number or Text hasn't worked)
Same problem occurs with a mixture of product codes, e.g. J2345es / 6789
(Tried saving the file as text and DBase, all of which didn't work)

Thanks for your input.

Malte