CODEWITHSUNDEEP
excelformattingexcel-2010excel-2007
chan
chan

Reputation: 47

How to format cells to add % at the end of every cell

I am trying to add % at the end of every cell value.

I have tried formatting the cells by going to the format cells -> custom -> type: 0.00%.

But this will multiply all the cell values by 100.

-0.031514839
-0.013255332
-0.007855065

I dont want to modify the cell value instead I just want to add % character at the end of every cell.

Upvotes: 0

Views: 761

Answers (3)

Mitchell Miller
Mitchell Miller

Reputation: 29

You almost had it right. Use a backslash in front of % to prevent the 100x multiplication !

Format -> Custom -> enter 0.00\%

Upvotes: 2

BruceWayne
BruceWayne

Reputation: 23283

Use a custom format of:

0.##############"%"

enter image description here

When using a custom format, putting a 0 ensures that a number will appear in that space. If it's a non-zero number, that number will show. The # means that a value will show only if a number exists in that position.

From Microsoft (See "Decimal places, spaces, colors, and conditions")

Use the number sign (#) if you want to display only the significant digits in a number. This sign does not allow the display non-significant zeros.

Use the numerical character for zero (0) if you want to display non-significant zeros when a number might have fewer digits than have been specified in the format code.

Some simple examples:
enter image description here

Upvotes: 3

chan
chan

Reputation: 47

Simple method is I just divided by 100 in the formula and added the cell format of 0.00%. S0, that the effect will be neutralized!

Upvotes: 0

Related Questions