linking from excel

  • Thread starter Thread starter Pierre
  • Start date Start date
P

Pierre

Hi all,

I link an excel file.

In a row, i have mixed type

some are seen as text, some as number

i.e. in one colum

a1234
234
b4
1

If i look at the link table i see a message # NUMBER!
each time the excel data is a number
and i see the correct data when it is a text.

How can i solve that simply?

Actually i use a function manually in excel to convert everything in text
then import
but i want to automatise that as much possible

any clues?

regards
Pierre
 
See replies to the thread "Import Excell Numbers as Text" by Ken Nicholas in
this newsgroup about 30 hours before your post.
 
See replies to the thread "Import Excell Numbers as Text" by Ken
Nicholas in this newsgroup about 30 hours before your post.
Click to expand...

It is sometimes difficult to find old messages back. It is not so difficult
to repeat the text:

For a mixed Column in Excel, I normally create a "calculated" Column in the
spreadsheet using the Excel Spreadsheet function like:

= Text([CellInMixedColumnAnsSameRow], "General")

This converts all values to Text regardless of the data type in the mixed
Column.

When I import, I skip the mixed Column and import the "calculated" Column.
 
I used Outlook Express and there is no problem finding recent posts.

And there is Google Groups search as well.
 
Back
Top