On Tue, 23 Aug 2005 23:14:24 -0700, LurfysMa
wrote:

I have a fairly simple spreadsheet with 30-40 calculatrions.

Some of the results appear to have a space on the right hand end. Most
of these are calculations, but some are literal numbers. Some are
formatted as currency and some as numbers.

The right justify button doesn't help.

I have checked all of the formatting parameters I can think of.

Can anyone suggest what is going on here?

Thanks

I discovered the problem. It really has nothing to do with some format
styles adding a trailing space and others not. It has to do with which
format is selected for negative numbers.

Somehow, some of my cells were changed so that negative numbers were
to be formatted in parentheses "(1234.56)". Since that involves a
character (the closing parenthesis) after the number, the style adds a
trailing space for positive numbers -- I presume so that they will
align in nice columns.

I didn't notice that difference when I was comparing cells that did
have the space with those that didn't.

All I had to do was select the cells with trailing spaces and select
the first negative number option (-1234.56) and all of the trailing
spaces disappeared.

My copy of Excel seems to have the default formatting style for
negative numbers set to (1234.56) for both the Number and the Currency
formats. Is there some way that I can change that default so that when
I select either Number or Currency formatting, negative numbers
default to being formatted as "-1234.56"?

Thanks

I suppose one could argue that


--
Running Excel 2000 SP-3 on Windows 2000