Notifications
Clear all
General Excel Questions & Answers
4
Posts
2
Users
0
Reactions
145
Views
Topic starter
Hi,
In the attachment I have a column of percentages with 2 decimal places.
I want to create a situation - that looks like column C
That will appear with different decimal places in the 3 different numbers -1.5% 2% (and not 2.0%) 0.25%
How can this be done? Is this a specific definition within the cell design pane?
Posted : 18/07/2019 4:04 am
Posted : 18/07/2019 7:23 am
Topic starter
Hi
I have set the template 0.##% here in the file
My problem is that you get an unnecessary point after the 2nd - 2.%
What's the solution?
Thanks!!
Posted : 24/07/2019 6:06 am
Hi Lea,
You can use Conditional Formatting to switch the formats for percentages without decimal places. See file attached.
Mynda
Posted : 24/07/2019 6:56 am
