Excel formatting show percent value without percent sign

0 votes
In Excel, I want to display figures like 0.95 as 95; formatting them as% displays 95%; but I want to remove the percent indicator. Is there anything I can do for this in "Custom Formatting"?
Dec 15, 2022 in Others by Kithuzzz
• 38,000 points
3,572 views

1 answer to this question.

0 votes

You can change how it appears while maintaining its fundamental worth.

This is a clumsy technique.

  1. Enable Wrap Text on the cells.

  2. You want a Custom Format.

  3. Enter the custom format as follows:

  1. Enter 0.00

  2. While holding down Alt, enter 0010. This will put in a line break

  3. Put in the %.

  4. Hit OK

The number will be converted to a percentage, but the percentage will appear on the second line. The cell will only display the number if it is set to wrap and is only tall enough to display one line.

The underlying number will remain the .xxxx and not that of 100 * .xxxx

enter image description here

answered Dec 15, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

Extract unique value from the range in Excel

The portability of spreadsheet functions like UNIQUE() ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
1,287 views
0 votes
1 answer
0 votes
1 answer

Thousand and million formatting for negative numbers (excel/ googlesheets)

Its not possible. What you could do is ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,600 points
1,302 views
0 votes
1 answer

On focus after tabbing of Excel drop down, automatically show list for selection

Put the following code in the Microsoft ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,600 points
644 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,246 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,020 points
1,109 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,020 points
4,390 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,276 views
0 votes
1 answer

Excel Conditional Formatting based on Adjacent Cell Value

The row number used in the formula ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,600 points
1,882 views
0 votes
1 answer

Number format in excel: Showing % value without multiplying with 100

You just need to select Custom from ...READ MORE

answered Oct 21, 2022 in Others by narikkadan
• 63,600 points
1,670 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP