Microsoft Query is changing a negative number into a date

M

mowens

I am using Microsoft Query to pull a subset of a large excel file however two
of my columns which are suppose to be numbers are not pulling in the negative
numbers. If I look at the query in microsoft database the number shows up as
a date/time string. I've tried formatting the original number as a number
but the query still won't read the negative number. How do I get the query
to read a negative number as a number and not a date.
 

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

Avoiding Leads, using SVT, and Linking Tasks correctly 0
Creating a Chart on form from selected data in query. 0
Setting column width in a table with a macro is not working 0
formatting negative numbers 1
MAX() of a range of negative values? 7
Custom format applicable to negative and positive numbers? 5
want negative product not positive 7
Negative Figures In A Query 5

Top