Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I align decimals in Excel when not all numbers have % sym.
I have a chart, 3 columns wide, 11 rows deep. The first and last numbers of
each column is a percentage, showing the % sign. The rows in between are also decimals, (1 decimal shown), but no % sign. Is it still possible to align these numbers by the decimals? I've tried everything I know of. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I align decimals in Excel when not all numbers have % sym.
Using this custom format gets close with a proportional spaced font: #0.00_)
A fixed font lines up perfectly. -- Kevin Backmann "sjgiles" wrote: I have a chart, 3 columns wide, 11 rows deep. The first and last numbers of each column is a percentage, showing the % sign. The rows in between are also decimals, (1 decimal shown), but no % sign. Is it still possible to align these numbers by the decimals? I've tried everything I know of. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I align decimals in Excel when not all numbers have % sym.
I would have used the % character:
#0.0_% The underscore says to reserve room for the next character, but don't show it. And you might have to adjust the format for the percentages, but you didn't share the number of decimals for those. sjgiles wrote: I have a chart, 3 columns wide, 11 rows deep. The first and last numbers of each column is a percentage, showing the % sign. The rows in between are also decimals, (1 decimal shown), but no % sign. Is it still possible to align these numbers by the decimals? I've tried everything I know of. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I retain the format of varying numbers in Excel? | Excel Discussion (Misc queries) | |||
Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
Converting imported numbers to decimals (rather than /100) | Excel Worksheet Functions | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
Aligning decimals in Excel ... | Excel Discussion (Misc queries) |