Copying Data to Excel - Numbers has Paragraph Returns

Your spread sheet program is reading those items in as text not numbers

  • The cell shows a quote preceding the text to illustrate this
  • Text is left justified, numbers right justified

Options

  • construct a cell formula to calculate a number value from the text in that field. Look at Value() or NumberValue(), see General Ledger Transactions Report - #12 by Patch
  • Use a table reading add-on for your spread sheet program to better extract the numbers
  • check / ensure number format consistency in Manger and your spread sheet program