specify data type in MS Query?

G

GoBobbyGo

I've got a query that pulls a field that has some text stuff, some blank
spaces, and some zeroes. I want it to treat that field as text, but it seems
to sometimes treat as text, sometimes treat as number.

I've got a dummy first line with a big ol' X in there, it STILL sometimes
treats it as a number. Suggestions?

Excel 2003, SP3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Import Error Row 1 Column 5 2
Template with fields and premade texts.. 0
Grouping Names in Mail Merge 0
Custom Number Format for text 13
Creating a Chart on form from selected data in query. 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Text in note pane of "normal" display suddenly much larger 1
question about the data type in excel 1

Top