## Desktop

Member
Posts: 62
Registered: ‎02-22-2017

# Percentage automatically multiplies x100

Hello all,

I want to just place a percentage sign at the end of my data, but when I change from decimal number to percentage my data is multiplied by 100. So 3,4 = 340%. I don't want this, I just want 3,4% in my dataset. How can I change this?

Greetings,

0xygen.

Accepted Solutions
Super User
Posts: 2,538
Registered: ‎11-29-2015

## Re: Percentage automatically multiplies x100

A genuine percentage is actually a number between 0 and 1.

So what you understand as a percentage of 3,4 is actually 0,034  (3.4 is actually 0.034)

Why not divide your number by 100 and then format it as a percentage?

Proud to be a Datanaut!

Community Support Team
Posts: 3,482
Registered: ‎09-27-2016

## Re: Percentage automatically multiplies x100

Hi @0xygen27,

Why so you divide 50 columns at once? Could you please share more details?

If you format the columns as percentage, please click the column->Data Type->Format, select percentage like the context highlighted in red line.

Best Regards,
Angelia

All Replies
Super User
Posts: 2,538
Registered: ‎11-29-2015

## Re: Percentage automatically multiplies x100

A genuine percentage is actually a number between 0 and 1.

So what you understand as a percentage of 3,4 is actually 0,034  (3.4 is actually 0.034)

Why not divide your number by 100 and then format it as a percentage?

Proud to be a Datanaut!

Member
Posts: 62
Registered: ‎02-22-2017

## Re: Percentage automatically multiplies x100

HI Phil_Seamark,

Highlighted
Member
Posts: 62
Registered: ‎02-22-2017

## Re: Percentage automatically multiplies x100

[ Edited ]

@Phil_SeamarkIs there a way to divide 50 colums at once?

Community Support Team
Posts: 3,482
Registered: ‎09-27-2016

## Re: Percentage automatically multiplies x100

Hi @0xygen27,

Why so you divide 50 columns at once? Could you please share more details?

If you format the columns as percentage, please click the column->Data Type->Format, select percentage like the context highlighted in red line.

Best Regards,
Angelia

Super User
Posts: 2,538
Registered: ‎11-29-2015

## Re: Percentage automatically multiplies x100

What is your source?  Are you using SQL