software

Format | Cells | Number and set for designed number of decimal places.
--
Rae Drysdalequot;nastechquot; wrote:

gt; saw in xl help file, but not re-searchable. trying to align decimal points.
gt;
gt; other problem exists with number/text formating, e.g.: 1.5B or 1.5M
gt;
gt; using some workarounds:
gt; - distribute formatting gets rid of seeing b/m
gt; - cond. formatting colors represents millions or billions
gt;
gt; - still have mis alignement:
gt; 104
gt; 21.
gt; 1.0
gt;
gt; - Recommend MS allow use of Custom formatting quot;in-cellquot; for text / number
gt; strings.
gt; if can't already do

hi, thanks. think I saw in help somewhere was specifically stated to align
decimal point, something of a centered on decimal point fashion. if shows
here in text:

100.0
1.511
0.21

quot;Rae Drysdalequot; wrote:

gt; Format | Cells | Number and set for designed number of decimal places.
gt; --
gt; Rae Drysdale
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; saw in xl help file, but not re-searchable. trying to align decimal points.
gt; gt;
gt; gt; other problem exists with number/text formating, e.g.: 1.5B or 1.5M
gt; gt;
gt; gt; using some workarounds:
gt; gt; - distribute formatting gets rid of seeing b/m
gt; gt; - cond. formatting colors represents millions or billions
gt; gt;
gt; gt; - still have mis alignement:
gt; gt; 104
gt; gt; 21.
gt; gt; 1.0
gt; gt;
gt; gt; - Recommend MS allow use of Custom formatting quot;in-cellquot; for text / number
gt; gt; strings.
gt; gt; if can't already do

Format/Cells/Number:Accounting, set number of decimal places.
If you choose number of decimanl places = 5, then
100.5 will appear as 100.50000
This is the closest I've been able to find.
If you don't want the $ mark, you can choose Symbol as none.

A decimal tab in Word will do what you're talking about. It even works with
alphabetoc characters. I wish there were something similar in Excel.

quot;nastechquot; wrote:

gt; hi, thanks. think I saw in help somewhere was specifically stated to align
gt; decimal point, something of a centered on decimal point fashion. if shows
gt; here in text:
gt;
gt; 100.0
gt; 1.511
gt; 0.21
gt;
gt; quot;Rae Drysdalequot; wrote:
gt;
gt; gt; Format | Cells | Number and set for designed number of decimal places.
gt; gt; --
gt; gt; Rae Drysdale
gt; gt;
gt; gt;
gt; gt; quot;nastechquot; wrote:
gt; gt;
gt; gt; gt; saw in xl help file, but not re-searchable. trying to align decimal points.
gt; gt; gt;
gt; gt; gt; other problem exists with number/text formating, e.g.: 1.5B or 1.5M
gt; gt; gt;
gt; gt; gt; using some workarounds:
gt; gt; gt; - distribute formatting gets rid of seeing b/m
gt; gt; gt; - cond. formatting colors represents millions or billions
gt; gt; gt;
gt; gt; gt; - still have mis alignement:
gt; gt; gt; 104
gt; gt; gt; 21.
gt; gt; gt; 1.0
gt; gt; gt;
gt; gt; gt; - Recommend MS allow use of Custom formatting quot;in-cellquot; for text / number
gt; gt; gt; strings.
gt; gt; gt; if can't already do

Actually, as Rae (almost) said Format/Cells/Number/Number gives the same
thing if you don't want the $ sign. I was thinking it did something else.

quot;nastechquot; wrote:

gt; hi, thanks. think I saw in help somewhere was specifically stated to align
gt; decimal point, something of a centered on decimal point fashion. if shows
gt; here in text:
gt;
gt; 100.0
gt; 1.511
gt; 0.21
gt;
gt; quot;Rae Drysdalequot; wrote:
gt;
gt; gt; Format | Cells | Number and set for designed number of decimal places.
gt; gt; --
gt; gt; Rae Drysdale
gt; gt;
gt; gt;
gt; gt; quot;nastechquot; wrote:
gt; gt;
gt; gt; gt; saw in xl help file, but not re-searchable. trying to align decimal points.
gt; gt; gt;
gt; gt; gt; other problem exists with number/text formating, e.g.: 1.5B or 1.5M
gt; gt; gt;
gt; gt; gt; using some workarounds:
gt; gt; gt; - distribute formatting gets rid of seeing b/m
gt; gt; gt; - cond. formatting colors represents millions or billions
gt; gt; gt;
gt; gt; gt; - still have mis alignement:
gt; gt; gt; 104
gt; gt; gt; 21.
gt; gt; gt; 1.0
gt; gt; gt;
gt; gt; gt; - Recommend MS allow use of Custom formatting quot;in-cellquot; for text / number
gt; gt; gt; strings.
gt; gt; gt; if can't already do