Solved: 1000 seperator comma

bkoenen · ‎10-26-2018

Hello,

I imported my data from an sql database into excel, from there to BI. SQL has no comma's so my values what where 65,61 become 6561 the problem is that bi sees this as a value of 6561,00I want it to be € 65,61 (check row3)

How do i this?

Regards Björn

v-chuncz-msft · ‎11-01-2018

@bkoenen,

You may check steps in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎11-01-2018

@bkoenen,

You may check steps in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.