Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Microsoft Query / Excel Date.Time | Excel Discussion (Misc queries) | |||
Creating Date Range in Pivot Microsoft Query | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
simple query changing set of numbers from positive to negative | Excel Discussion (Misc queries) | |||
Changing Server on a Microsoft Query | Excel Discussion (Misc queries) |