AnsweredAssumed Answered

Different fields format

Question asked by MAKALENG on Mar 11, 2017
Latest reply on Mar 11, 2017 by Jason Wood


I am having data from supplier the problem is his data is different from mine, his amount comes in with currency sign mine doesn't and

instead of . his is ,

that is while my data is 987.34 , his is $ 987,34. How will I relate the two?

same as date 12/02/2016 v 2016/02/12