How do I post the format?
It's definitely not a negative number - sometimes it happens with text, too.
For example, I have some text right justified that seems to align right
against the edge of the column. But some of it has a small space to the
right. So when you look at the column, the right edge doesn't line up. I'm
sure this is a simple setting - I just don't know where it is.
Thanks!
--
ljb


"Fred Smith" wrote:

We can only guess since you haven't posted the format, buy my guess is you are
using parentheses to show a negative value. In this case, the positive values
need to leave room at the end of the number for all number to line up properly.
You will likely see _) at the end of your format -- this tells Excel to leave
room for the ) on positive numbers so your decimals will line up.

The format that doesn't line up didn't have the _) part.

If you would prefer a more accurate answer rather than just a guess, then post
the format.

--
Regards,
Fred


"ljb" wrote in message
...
Thanks - that worked perfectly. Do you know why this would happen? I'm
curious to know what the setting was that was wrong. Thanks again.
--
ljb


"Chad" wrote:

Try copying and pasting the format from a cell that is correctly formatted.

-Chad

"ljb" wrote:

I am editing a worksheet someone else created. It's very simple - just a
bank statement-type sheet. The column with the numbers (format -
currency-right justified) all line up except one, which is off by a little
bit. What am I doing wrong? I've looked all through the formatting
possibilities.
Thanks
--
ljb