Decimal Alignment
You can try this formula to pad blank spaces at the end to make the decimals
line up. A couple of things to note... You will need to use a proportional
font such as Courier and the number 5 in the formula refers to thenumber of
characters after the decimal. It must be at least as large as the max number
of characters after the decimal...
--
HTH...
Jim Thomlinson
"notloiseweiss" wrote:
tried that and it doesn't seem to work. It's my understanding (from reading
other posts) that custom formats only work for numeric data???
"Sandy" wrote:
Use the cutsom format ???.??? Highlight the range you want rightclick
== format cells == number tab == custom, then paste this into the
textbox. Also look in the help section "Guidelines for custom number
formats"
Sandy
notloiseweiss wrote:
I am looking for a way to align a column by the decimal point. My data is
both numeric and character. I could make the data all character, but I'm
still not sure how to align string data by a particular character.
i.e.-
101.23**
1.26*
1.11***
12.12*
1.05
Help is appreciated.
|