I have a excel spreadsheet that im importing into Business objects. One
of the columns is a combination of text and numbers. Even when I format
the column as text the ODBC link will only pick up the numbers. If I
cconcatinate a " ' " into the beginning of the cells it will then pick
up everything. Obviously this gets me by for the minute but this isnt
scalable for further reporting. Do you know of a way to make the
column save as a true text field?


--
ibirthwright
------------------------------------------------------------------------
ibirthwright's Profile: http://www.excelforum.com/member.php...o&userid=25963
View this thread: http://www.excelforum.com/showthread...hreadid=393306