numbers (currency) don't line up on decimal
 

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

numbers (currency) don't line up on decimal
 

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

numbers (currency) don't line up on decimal
 

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

numbers (currency) don't line up on decimal
 

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

numbers (currency) don't line up on decimal
 

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

numbers (currency) don't line up on decimal
 

Right-click on the cell, choose Format Cells..., choose Custom, and copy the
format in the Type: box. Then paste that to your message.

There is no formatting for text cells, so if they don't line up it has to be the
data. I suspect you have a space at the end of the non-aligning cell. Select the
cell, hit F2 and see where the cursor is. Is there an extra space at the end of
the data? If so, remove it.

--
Regards,
Fred


"ljb" wrote in message
...
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

numbers (currency) don't line up on decimal
 

Possibly FormatCellsAlignmentHorizontalRight Indent is set to 1

Numbers can also have this alignment.


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 17:55:58 -0800, ljb wrote:

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!