title: SQLite How to handle Negative numbers with Negative Sign at the end
body: <p>We've never experienced this before. We are importing Tab Delimited TXT files that include numeric columns. Negative numbers have the indicator behind the number and not in front (e.g. 550.00- rather than -550.00). </p>
  
  <p>We are using SQLite Expert Professional. When reviewing the import results in the table, any number with the negative sign in the back was converted to the negative sign in the front but everyone of these cells are highlighted in blue (we are not sure why SQLite Expert is doing this but assume it has meaning). In addition, when querying and summing they are being ignored causing the resulting value to be higher than expected.</p>
  
  <p>The field types are FLOAT and DECIMAL</p>
  
  <p>We have googled and cannot find any results about negative sign location.</p>
  
  <p>Appreciate any assistance on how to handle this.</p>