Column not showing decimal sometimes

[Rob]

I have a column with dollar amounts and most of the time it shows the entire
amount as I entered but a few of them aren't showing the cents for some
reason. When I sum the columns it calculates correctly but I would like to
show the cents when I print.

Also, how can I get it to automatically add the $? One column I have has
amounts in every row and on those it does it automatically but sometimes
other columns don't have a transaction on every row and those I have to type
it each time. Not a big deal but just wondering.

 

[Rob]

Basically, its rounding up or down and I dont' want it to.

 

[shakey]

I have a column with dollar amounts and most of the time it shows the
entire amount as I entered but a few of them aren't showing the cents for
some reason. When I sum the columns it calculates correctly but I would
like to show the cents when I print.

Also, how can I get it to automatically add the $? One column I have has
amounts in every row and on those it does it automatically but sometimes
other columns don't have a transaction on every row and those I have to
type it each time. Not a big deal but just wondering.

Guaranteed way
Select a correctly formatted cell from the correctly formatted column then
COPY
Select the entire column that has problems and Paste Special Format.
That should for it to be the same.
SG

 

[Rob]

Nice, just what I needed. Thanks.