P
Phil au
I have been playing with MS Query in Excel2000, and have
noticed that when I type data that contains both numbers
and letters, query doesn't recognise it and does not
display it.
I have tried to format the cell so that it is recognised
as text but still it does not recognise it. It is also
interesting to note that MS Query puts a decimal point and
a 0 behind the data that are numbers.
Please tell me what I have to do to make MSQuery recognise
data that contains both numbers and letters
noticed that when I type data that contains both numbers
and letters, query doesn't recognise it and does not
display it.
I have tried to format the cell so that it is recognised
as text but still it does not recognise it. It is also
interesting to note that MS Query puts a decimal point and
a 0 behind the data that are numbers.
Please tell me what I have to do to make MSQuery recognise
data that contains both numbers and letters