0

I have two sets of data that I want to load into a separate Excel sheet. One set is shown as percentage (as I want It to be shown), and the other is shown in numbers, see example below. Changing the dataset 1 to percentage shows huge percentages.

Does anyone know how to convert the numbers so the two sets of data are shown as a percentage?

    Dataset 1   Dataset2
1   0.950000    0,96%
2   0.400000    0,40%
3   1050000,00  1,05%
4   0.400000    0,40%
5   0.020000    0,20%
Peter
  • 65
  • 1
  • 12
  • Are you sure your example is correct? 0.95 => 0.96% and 1050000 => 1.05%? – Dominique May 22 '19 at 10:12
  • Yes you are write, but has something to do with . and , When I press the % button it 1050000 becomes 1050000%, not 1.05%. – Peter May 22 '19 at 10:47

1 Answers1

1

Taken from here, credits to @AxGryndr

Select Dataset1 range and apply custom format:

0,00##\%

Or

0.00##\%

Depending if your system uses a dot or comma.

JvdV
  • 70,606
  • 8
  • 39
  • 70
  • @Peter, did this answer your question? If so, please refer to [this link](https://stackoverflow.com/help/someone-answers) – JvdV May 28 '19 at 07:03