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