How to ensure that $ and not amount counts are pulled into PT

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After importing a XLs worksheet (from another application People soft) The
amount in US$ come in as $values (what I need) but sometimes am amount count
comes into the table instead. I have tried formatting the ceel to ensure
that the US$ amount are numbers but this has the same result.. that is
sometime the $amounts are pulled as $values or sometimes the US$ amounts are
pulled as counts that is the number of entries making up the US$ total
 
Back
Top