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

formatting excel-2007 excel-2010 excel-2013
SharpCoder picture SharpCoder · May 29, 2013 · Viewed 140.7k times · Source

When I set format of a cell as %, it automatically multiply the value with 100 & show the value. So 5.66 becomes 566 %.

I want to apply % format on a column but want to keep the values same as before. I just want % sign to be shown along with the value. To achieve this, I used following format 0.00##\%

Now I want to show negavtive values in RED color without '-' sign(negative) and the values should be wrapped in brackets. so -5.66 should be shown as (5.66%) in red color.

Please help

Answer

AxGryndr picture AxGryndr · May 29, 2013

You just have to change to a Custom format - right click and select format and at the bottom of the list is custom.

 0.00##\%;[Red](0.00##\%)

The first part of custom format is your defined format you posted. Everything after the semicolon is for negative numbers. [RED] tells Excel to make the negative numbers red and the () make sure that negative number is in parentheses.

Related questions

How to format numbers as currency string?

I would like to format a price in JavaScript. I'd like a function which takes a float as an argument and returns a string formatted like this: "$ 2,500.00" What's the best way to do this?

Read More
Convert a date format in PHP

I am trying to convert a date from yyyy-mm-dd to dd-mm-yyyy (but not in SQL); however I don't know how the date function requires a timestamp, and I can't get a timestamp from this string. How is this possible?

Read More
Change date format in a Java string

I've a String representing a date. String date_s = "2011-01-18 00:00:00.0"; I'd like to convert it to a Date and output it in YYYY-MM-DD format. 2011-01-18 How can I achieve this? Okay, based on the answers I retrieved below, …

Read More