View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 145
Default 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