Formatting a number to look like a Percent without a percent sign
We often want a column of decimals to have a percent sign only on the first
number in the column, so: ..553 ..554 (.345) need to be formatted to look like 55.3% 55.4 (34.5) where all the decimals align vertically. I can't figure out how to do this without multiplying the second and third cells by 100, which is a bad solution. Any ideas? Thanks. |
format custom 0.0
"David Iacoponi" wrote: We often want a column of decimals to have a percent sign only on the first number in the column, so: .553 .554 (.345) need to be formatted to look like 55.3% 55.4 (34.5) where all the decimals align vertically. I can't figure out how to do this without multiplying the second and third cells by 100, which is a bad solution. Any ideas? Thanks. |
And by the way, multiplying by 100 is the only solution for what you want.
"David Iacoponi" wrote: We often want a column of decimals to have a percent sign only on the first number in the column, so: .553 .554 (.345) need to be formatted to look like 55.3% 55.4 (34.5) where all the decimals align vertically. I can't figure out how to do this without multiplying the second and third cells by 100, which is a bad solution. Any ideas? Thanks. |
All times are GMT +1. The time now is 01:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com