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%
Improve this question
2
  • Are you sure your example is correct? 0.95 => 0.96% and 1050000 => 1.05%? Commented May 22, 2019 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%. Commented May 22, 2019 at 10:47

1 Answer 1

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.