View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ohdharleyboy ohdharleyboy is offline
external usenet poster
 
Posts: 6
Default Excel 2003 - negative following the number

Hello all-

I have imported a column of numbers into an Excel 2003 spreadsheet from an
in house program. When there is a number in the column that is negative, it
displays the negative sign after the number (45.50- instead of -45.50). Is
there a way to move the negative sign for the entire column to the front of
the number? Thanks - Jason