Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number formatting when importing from Access to Excel | Excel Discussion (Misc queries) | |||
Clean does not remove hidden formatting on a number | Excel Worksheet Functions | |||
Pivot Table Drill Down Number Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Is there a way to have two values (percent and number) in a label. | Charts and Charting in Excel |