Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Data-Changing Numeric Formatting
Hi All,
I am importing external data via database query. There is one column of data that is in the positive position that needs to be converted into the negative position (entire column). i.e. 21.63 needs to read as -21.63. Can this be done? Thanks in advance. Cheryl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Data-Changing Numeric Formatting
Just negate the value in your SQL:
select -t.columname from tablename t Tim "Cheryl" wrote in message ... Hi All, I am importing external data via database query. There is one column of data that is in the positive position that needs to be converted into the negative position (entire column). i.e. 21.63 needs to read as -21.63. Can this be done? Thanks in advance. Cheryl |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
External Data-Changing Numeric Formatting
Thanks Tim. Couldn't believe the answer could be so simple!!!!
Cheryl "Tim" wrote: Just negate the value in your SQL: select -t.columname from tablename t Tim "Cheryl" wrote in message ... Hi All, I am importing external data via database query. There is one column of data that is in the positive position that needs to be converted into the negative position (entire column). i.e. 21.63 needs to read as -21.63. Can this be done? Thanks in advance. Cheryl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing External Data Location | Links and Linking in Excel | |||
Changing Query to get external data | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
Pivot and changing External data source | Excel Discussion (Misc queries) | |||
Stripping out non-numeric values from external data source | Excel Programming |