Remove trailing zero; percentage

Topic

New Reply

I am entering a lot of percentages into an Excel (2007). The data are expressed to three decimal accuracy (1.312% for example). And I have the column set up as percent, with three decimal places.

However, for my final report, I am asked to delete trailing zeros. For instance, 1.300% is not appreciated; I am asked to report it as 1.3%. (Sheesh! :()

As I have some 3,000 entries, any suggestions on how to automate this?

Reply | Quote

Replies

Select all of the affected cells and change the number of digits behind the decimal point. There should be an icon for this.

Reply | Quote

John,

You need to set up a custom format, see below. Select all the cells involved before entering the format menu. :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

RetiredGeek: I think you meant 0.0##% [Otherwise the 1.3% would display as 0.013.]

JohnD1: Personally I do not like removing just trailing zeroes as it makes the precision representaion variable. I would go for custom number format of 0.0% and have 1.300% and 1.312% both display as 1.3% instead of having 1.300% display as 1.3% and 1.312% display as 1.312%. Unless specified the typical presumption is ±.5 in the last decimal so 1.3% suggests (with no otehr information) a number between 1.25-1.35%, where 1.300% suggests that it is between 1.2995-1.3005%

Steve

Reply | Quote

RetiredGeek: I think you meant 0.0##% [Otherwise the 1.3% would display as 0.013.]
Steve

Steve,

Right you are! :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

RetiredGeek: I think you meant 0.0##% [Otherwise the 1.3% would display as 0.013.]

JohnD1: Personally I do not like removing just trailing zeroes as it makes the precision representaion variable. I would go for custom number format of 0.0% and have 1.300% and 1.312% both display as 1.3% instead of having 1.300% display as 1.3% and 1.312% display as 1.312%. Unless specified the typical presumption is ±.5 in the last decimal so 1.3% suggests (with no otehr information) a number between 1.25-1.35%, where 1.300% suggests that it is between 1.2995-1.3005%

Steve

Oh my! Custom formatting!

(Know why I have a flat forehead? I ask the question; I get the answer; I slap my forehead with my palm saying “Of Course! Why didn’t I think of it?”)

Thanks to all!

And, yes I am quite familiar with the varying precisions implied by dropping the final zero(s). This is not of my doing; I am merely the messenger at this point. (What I am doing is analyzing data sent to me; I need to present my report in the manner that the data was given me. They drop final zero–I drop final zero.)

Reply | Quote