Jacques Naude
New Member
Hallo
My problem sounds simple, but I am failing to resolve.
My data source is from SQL
I used LEFT and LEN functions in PowerPivot to get this 2 columns
However, If I format them, only the smaller amounts gets formatted correctly
See the 1000 separator, They are all formatted like the attached Picture
The original Columns which doesn't contain the LEFT and LEN functions, can format correctly
My problem sounds simple, but I am failing to resolve.
My data source is from SQL
I used LEFT and LEN functions in PowerPivot to get this 2 columns
However, If I format them, only the smaller amounts gets formatted correctly
See the 1000 separator, They are all formatted like the attached Picture
The original Columns which doesn't contain the LEFT and LEN functions, can format correctly