If you change the font size or even the font, you may not see the same "indent".

But in my simple tests, using the indent on the alignment tab worked fine.

Ron Rosenfeld wrote:

On Fri, 31 Oct 2008 01:29:14 -0400, "Jack B"
wrote:

Dave,

The only draw back with the
#,##0.00" " is that it doesn't work the same for all cells. That is if some
cells have different types of entries. Even Bold numbers do not shift to
the left the same distance.


Could you give some examples of not working the same?

I entered a variety of numbers in both bold and normal font, and they all
seemed to shift the same from the right margin.
--ron

--

Dave Peterson